SQL Server Performance
 As
databases get larger in size and functionality, extra attention to SQL
Server performance tuning becomes an essential part of every database
administrator and database developer's job. The
following articles are designed to help you stay ahead of the curve when it
comes to SQL Server performance:
Understanding SQL Server Memory Internals
Like all database servers, Microsoft SQL Server thrives on memory. Each instance of Microsoft SQL Server
has its own memory address space. The SQL Server address space (Virtual
memory allocation by Windows) consists of two main components: Executable
Code and Memory Pool. Let's examine each of these components in more details.
Read more...
Advantages of SQL Server 2005 64-bit
64-bit
processors are expected to dominate the markets by the end of 2007. It is clear
that the industry is moving towards the 64-bit platform fast, especially for
server hardware. The move towards the 64-bit platform has been driven by
lower hardware prices, especially after the introduction of x64 architecture by both Intel
(EM64T) and AMD (AMD64). Read more...
SQL Server blocking and deadlocks
The more blocking happens on SQL Server the less concurrency the system. A certain amount of
short blocks are unavoidable but too
many blocks for longer periods of time can degrade performance and
increase the chances of
SQL Server deadlocks. Read
more...
SQL Server performance counters
The
most important performance counters to watch when tuning SQL Server
performance are CPU usage, memory usage, cache hit ratios, and disk I/O. Even though CPU capacity and available memory are crucial, disk I/O
is frequently the cause of bottlenecks in most systems. Paying extra
attention to disk I/O and cached disk access is worthwhile.
Read more...
SQL Server performance tips
SQL Server performance tuning can consume a considerable amount of time and
effort. The following list is a quick guideline that you should keep in mind
when designing and developing SQL Server database applications.
Read more...
SQL Server index scanning
Fragmented
SQL Server indexes can result in performance degradation and longer index
scanning time. DBCC INDEXDEFRAG helps improve index scanning performance by
defragmenting clustered and nonclustered indexes.
Read more...
|
