Browse by Tags

Max Worker Threads Configuration in SQL Server 2005
In 2005 the default value for this setting has changed from 255 (SQL2k) to 0 (dynamic in SQL2k5). According to various sources, the following table shows the automatically configured number of Max Worker Threads for SQL Servers (2005) with different numbers...
How to compare the configuration of two SQL 2005 Servers?
It is important to compare the configuration of two servers, for ex. The Test and the production servers, or more important, the production and a disaster recovery stand by server. So, how can I compare the configuration of two SQL Servers? Well, the...

Search

Go

This Blog

Tags

Syndication