Community

Tips for Performance Tuning SQL Server's Configuration Settings

If you are running SQL Server 6.5, don't make the most common mistake made by DBAs, and that is to accept the default Memory setting, which is either 8MB or 16MB, depending on how much RAM the physical server has. This number tells SQL Server how much RAM is can use out of the available RAM on N

Read More - Register for Free Membership