Historian Limitations?

Has anyone run into limitations using the Ignition Historian? We are running a system with 5k tags at a 1s interval, giving us around 50 million rows a week (rows in the sqlt_ partition). It feels to me that this should be a reasonable amount of data, but whenever we enable the historian our server begins to drift. Our database is SQL Server Standard with 8 core, 64GB RAM, 3TB space, while our gateway is 16 core, 128GB RAM, 500GB space.