Browse by Tags

SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?

Published 5 February 8 2:57 AM | SSQA.net

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

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

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario

Published 17 January 8 2:23 AM | SSQA.net

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

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

TSQL to findout blocking and locks on a SQL Server?

Published 7 December 7 1:8 PM | SSQA.net

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly...

Filed under: sql server, performance, indexes, blocking, security, insert, tsql, locks, deletes

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

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

Published 4 September 7 9:32 AM | SSQA.net

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...

Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution

Performance - check whether it is affecting application or system, don't blame SQL Server alone

Published 3 September 7 9:42 AM | SSQA.net

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

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

Dedicated Administrator Console (DAC) - saved an important day for a DBA

Published 4 August 7 9:9 AM | SSQA.net

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...

Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation

Table fragmentation, Index contention and locking issues to resolve

Published 31 July 7 9:31 AM | SSQA.net

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

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

Why is a SPID blocking itself in sysprocesses?

Published 27 July 7 3:29 AM | SSQA.net

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

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

Row versioning-based transaction isolation features in SQL 2005

Published 6 May 7 4:47 AM | SqlServer-QA.net (SSQA)

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

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