Browse by Tags

• analysis
• application
• contribution
• dac
• dba
• fragmentation
• high cpu
• investigation
• locking
• loss
• management
• oltp
• parallelism
• process
• profiler
• query
• queue
• sac
• security
• self
• SQL Server
• statistics
• stats
• stored procedure
• table
• trace
• tuning
• wait

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

  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 Read More... Posted Wednesday, September 05, 2007 12:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, blocking, statistics, stored procedure, tuning, parallelism, contribution, stats

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

  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... Posted Tuesday, September 04, 2007 12:42 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, query, blocking, table, application, wait, queue, high cpu, oltp

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

  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 Read More... Posted Sunday, August 05, 2007 12:09 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, blocking, management, dac, sac, dba, analysis, investigation

• Table fragmentation, Index contention and locking issues to resolve

  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... Posted Wednesday, August 01, 2007 12:31 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, blocking, profiler, locking, trace, process, loss, fragmentation, table

• Why is a SPID blocking itself in sysprocesses?

  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... Posted Friday, July 27, 2007 6:29 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, self, blocking