Tuning SQL Statements on Microsoft SQL Server 2000

Posted by Anonymous 0 komentar

Tuning SQL Statements on Microsoft SQL Server 2000.pdf ebook manual guide This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. We discuss the techniques available using Microsoft's graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer, as well as providing a brief overview of Quest Software's query tuning tools. In addition to tuning methods, we'll show you several best practices you can apply to your SQL statements to improve performance. [All examples and syntax are verified for Microsoft SQL Server 2000.] After reading this paper, you should have a basic understanding of query tuning tools and techniques available with the Microsoft tool kit. We will cover a variety of querying techniques that improve performance and speed data read operations. SQL Server provides you with capabilities to benchmark transactions by sampling I/O activity and elapsed execution time using certain SET and DBCC commands. In addition, some DBCC commands may be used to obtain a very detailed explanation of any index statistic, estimate the cost of every possible execution plan, and boost performance. The SET and DBCC commands are fully detailed in the Quest white paper entitled "Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using SET and DBCC," the first white paper in a four part series on performance tuning.

Tuning SQL Statements on Microsoft SQL Server 2000