Performance Tuning Windows 2000 When Running SQL Server

Windows 2000 supports both Basic and Dynamic disks types. From a performance perspective, one type of disk is not faster than the other. Because of this, you should decide on the type of disk type you choose based on what your I/O needs are. For example, if you want to cluster SQL Server, you have no choice but to use the Basic disk type on the shared disk array. [6.5, 7.0, 2000, 2005] Added 12-28-2001


Windows 2000 supports a little known and used feature called Quality of Service (QoS). In most network designs, no network traffic is given higher priority over other network traffic. This means that users who access SQL Server over your network have to compete with users who are listening to Internet radio on their desktops.

If you find that your SQL Server network traffic does not always have the priority it should in your network, consider looking into QoS. QoS allows you to assign a higher priority to some network traffic than others. For example, you could assign SQL Server network traffic a higher priority than Internet-related traffic.

While Windows 2000 supports QoS (using the QoS RSVP service), in order for QoS to be implemented in an organization’s network, it also must be implemented on all other network devices, such as routers and switches. This means, of course, that it is not easy to implement. But, if you are planning on redoing your current network infrastructure, or plan on building a new one, you should investigate what QoS has to offer your company, from a performance perspective. [6.5, 7.0, 2000, 2005] Added 1-25-2002


Leave a comment

Your email address will not be published.