Lohn Solutions

I was On call this week and one of our databases files became over 90% full.  This is the threshold we set to alert us to manually expand any file.  We have autogrowth just in case, but we want to manually expand files after hours to avoid the performance impact on SQL server when expanding [...]

I would suggest once a quarter, set up a performance monitor log to collect the following counters for a couple of 24 hour periods.  Look at the results in both a graph and report forms to determine the peak usage times and to see if there are any bottlenecks on your SQL server.

Here are the [...]