Browse by Tags

• application
• backups
• benchmarking
• best practice
• best practices
• blog
• blogs
• buffer
• cpu
• cumulative update
• databases
• dirty
• dmv
• execution plan
• FAQ
• forums
• fragmentation
• high cpu
• hotfix
• index plan
• indexes
• integration
• isolation
• kba
• locking
• loss
• maintenance plan
• memory
• monitor
• monitoring
• msdn
• newsgroups
• oltp
• performance
• poor
• process
• profiler
• query
• queue
• resources
• security
• self
• service pack
• sql server
• sql server central
• table
• table variable
• tablesample
• temp tables
• tempdb
• trace
• tsql
• wait

SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?
23 May 08 01:44 AM | SQL Master | 2 Comments   

Secured by default, secured by design is the buzzword and catchy stuff for any Enterprise IT administrators. Then it comes about standards and policies to follow such as ISO , with the recent threats (last 10 years) and vulnerabilities within IT world Read More...

Filed under: sql server, security, blocking, hotfix, service pack, best practices, cumulative update

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
05 February 08 01:57 AM | SQL Master | 6 Comments   

SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question Read More...

Filed under: performance, sql server, security, query, blocking, best practice, blogs, index plan, newsgroups, sql server central, forums

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
17 January 08 01:23 AM | SQL Master | 2 Comments   

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices.aspx Read More...

Filed under: performance, sql server, blocking, msdn, tablesample, tempdb, best practice, FAQ, monitoring, maintenance plan, benchmarking, table variable, temp tables

SQL Server 2005: Slow running queries - Blocking and Index problems
24 September 07 07:19 AM | SQL Master | 2 Comments   

As a DBA you must be aware that slow or long running queries can contribute to excessive resource consumption and be the consequence of blocked queries. No database application is exception to this behaviour, so the queries that also run slowly because Read More...

Filed under: sql server, dmv, blocking, indexes, blog, tsql, poor

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
20 September 07 08:40 AM | SQL Master | 2 Comments   

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, Read More...

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

Performance - check whether it is affecting application or system, don't blame SQL Server alone
03 September 07 07:42 AM | SQL Master | 2 Comments   

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL Read More...

Filed under: performance, sql server, security, query, wait, blocking, table, application, oltp, high cpu, queue

Table fragmentation, Index contention and locking issues to resolve
31 July 07 07:31 AM | SQL Master | 2 Comments   

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to Read More...

Filed under: performance, sql server, blocking, profiler, table, fragmentation, process, trace, locking, loss

Why is a SPID blocking itself in sysprocesses?
27 July 07 01:29 AM | SQL Master | 1 Comments   

This was the question asked during an interview that was attended by one of my friend, I'm not sure how he managed to answer but came to me asking how it is possible. For your information af ter you apply SQL 2000 Service Pack 4, you might observe that Read More...

Filed under: performance, sql server, query, blocking, self

How to find dirty buffer pages and clear them - SQL Server
21 May 07 08:22 AM | SQL Master | 0 Comments   

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 )method. Read More...

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

SQL Server 2005 how to find a rarely used index?
18 May 07 03:31 AM | SQL Master | 1 Comments   

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 Read More...

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

Row versioning-based transaction isolation features in SQL 2005
06 May 07 02:47 AM | SQL Master | 0 Comments   

More information about nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications. Read More...

Filed under: performance, sql server, integration, isolation, blocking