 |
How to improve performance with pinned tables
|
| Total Hit (2592) |
SQL Server experts know that the DB engine never accesses directly the data pages on disk; rather it uses a special module called "Cache Manager". It is possible, by using some T-SQL commands, to force the selected tables to stay in the buffer for a longer time. This technique increases the performa
....Read More |
Rating
 |
|
|
|
Improve I/O throughput of intelligent subsystems to favor SQL Server
|
| Total Hit (2491) |
One of the peculiar features of Microsoft SQL Server is its capability to keep alive multiple threads at the same time for performing I/O operations. The configuration options that affects how many threads available for these operations is max async IO. The default value for this option is 32, which
....Read More |
| Rating
|
|
|
|
Monitor stored procedure and batch activity from remote workstations
|
| Total Hit (2472) |
Using the sp_user_counterX stored procedure (where X is a number between 1 and 10) you can set internal SQL Server counters. This values are read by the Performance Monitor, the standard Windows utility that monitors system activity. The Performance Monitor is able to monitor not only the activities
....Read More |
| Rating
|
|
|
|
|
|
|
|
Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
|
| Total Hit (2969) |
In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 and 2000 for administering and monitoring.
DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logica
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
Benchmarking Performance of a Query - Part 2 CPU and I/O
|
| Total Hit (2167) |
This is the second article in a series discussing benchmarking T-SQL query performance. The first article in this series discussed different methods of capturing the elapsed time of a T-SQL batch, pieces of a batch, or a single T-SQL statement. This article will discuss how to determine the amount o
....Read More |
| Rating
|
|
|
|
Benchmarking Performance of a Query - Part 1 Elapsed Time
|
| Total Hit (951) |
How many times have you had more than one way to do something and wanted to determine which method was faster and/or which one used more resources? I am going to guess that most developers have run across this dilemma more than once. So how do you decide with method is faster--or which method requir
....Read More |
| Rating
|
|
|
|
Application Design Optimization Tips
|
| Total Hit (1054) |
Here are fifteen tips that you can use to ensure your Application Designs are performing in the most efficient manner possible.
|
| Rating
|
|
|
|
|
|
Examining SQL Server's I/O Statistics
|
| Total Hit (851) |
Reading and writing to the disk is the heart of what any database management system does, SQL Server included. Input/Output (I/O) performance can make or break an application. This article discusses the diagnostic tools that can be used to examine SQL Server's I/O statistics so that you can make fac
....Read More |
| Rating
|
|
|
|
Scripting Traces for Performance Monitoring on SQL Server
|
| Total Hit (1014) |
The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor aggregate performance of an entire SQL Server i
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
RDBMS Performance Tuning Guide for Data Warehousing
|
| Total Hit (1898) |
This performance tuning guide is designed to help database administrators and developers configure Microsoft® SQL Server™ 2000 for maximum performance and to assist in determining causes of poor performance of relational databases, including those used in data warehousing. It also provides guideline
....Read More |
| Rating
|
|