Browse by Tags

• application
• backups
• benchmarking
• best practice
• blogs
• cpu
• databases
• execution plan
• FAQ
• forums
• fragmentation
• high cpu
• index plan
• integration
• isolation
• kba
• locking
• loss
• maintenance plan
• monitoring
• msdn
• newsgroups
• oltp
• process
• profiler
• query
• queue
• resources
• security
• self
• sql server
• sql server central
• table
• table variable
• tablesample
• temp tables
• tempdb
• trace
• wait

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

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

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