Updated: March 13,1996 TechNet Logo Go To TechNet Home Page

PSS Focus: Optimizing SQL Server 4.2x

Welcome to the sixth installment of the PSS Focus of the Month, a monthly feature on the TechNet CD brought to you by Microsoft Product Support Services (PSS). PSS is the primary support organization for Microsoft products worldwide. Each month in this column we'll explain several support issues that PSS engineers feel are important for corporate and support customers to know about, and we'll point you toward the relevant Knowledge Base articles, Application Notes, white papers, Resource Kits and other information on TechNet that contain troubleshooting tips, workarounds, and in-depth background information.

Product: SQL Server 4.2x

Topic:Optimizing SQL Server 4.2x

Issue Summary

The Knowledge Base articles in this focus group cover optimizing SQL Server 4.2x.

Q numbers and titles of Knowledge Base articles on TechNet

Q110352, "Optimizing SQL Server Performance"

Q89385, "Optimizer Index Selection with Stored Procedures"

Q46434, "Writing Efficient Queries and Stored Procedures"

Q115050, "When to Use Tempdb in RAM"

Q112539, "Max Async IO Configuration Parameter"

Q111405, "SQL Server and Windows NT Thread Scheduling"

Q110983, "Recommended SQL Server for Windows NT Memory Configurations"

Background information resources on the TechNet CD

Optimizing SQL Server Performance

MS SQL Server 4.2x Technology and Architecture

MS SQL Server 4.2 Release Notes

Other TechNet Resources

MS SQL Server 4.2x Troubleshooting Guide

Return to the Top

Click Here to Search TechNet Web Contents

TechNet CD Overview

Microsoft TechNet Credit Card Order Form
At this time we can only support electronic orders in the US and Canada. International ordering information.

Go To TechNet Home Page

©1996 Microsoft Corporation

Microsoft homepage

Go To Microsoft Home Page