Our SQL Server 2008 DB seems to slow down in the afternoon. I am wondering if the auto grow settings within SQL are incorrect and if they could be adjusted to greatly improve our performance. I believe it is either that or we just need faster hardware. I pulled a query of growth events. Here is a very small snippet with some of the slowest times:
Data File Auto Grow DB DB_CurrentVersion_Data 10/17/2017 29:43.5 29:43.8 246000
Data File Auto Grow DB DB_CurrentVersion_Data 11/9/2017 33:17.4 33:17.6 226000
Data File Auto Grow DB DB_CurrentVersion_Data 11/9/2017 33:22.0 33:22.3 220000
Data File Auto Grow tempdb tempdev 11/11/2017 35:52.9 35:53.1 206000
I also pulled the growth report from within mgmt studio, and see that in the afternoon there are thousands of growth events, 1 Mb each. Sometimes 4 or 5 per second. This is an OLTP database, but reports have to be pulled while it is running as well. The size of the database (on disk) seems to increase rapidly as well.