Browse by Tags

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

Published 20 September 7 10:40 AM | SSQA.net

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...

Filed under: sql server, performance, databases, blogs, blocking, query, kba, cpu, execution plan, backups, resources, high cpu, FAQ

How to find dirty buffer pages and clear them - SQL Server

Published 21 May 7 10:22 AM | SSQA.net

Dirty buffer pages are nothing but consuming more memory for even smaller queries on the SQL Server. By default the DBA shouldn't worry about these dirty pages in the buffer pool as they are taken care by the system using Write Ahead Logging ( WAL...

Filed under: sql server, memory, databases, blocking, dmv, buffer, dirty

SQL Server 2005 how to find a rarely used index?

Published 18 May 7 5:31 AM | SSQA.net

For a SQL Server database having an index is always beneficial and from performance point of view too. But how about the clustered index which is occupying space on the database that is not used by any of the queries in the database. The Query Optimizer...

Filed under: sql server, indexes, databases, blocking, perfmance, blog, monitor