Browse by Tags

• application
• fragmentation
• high cpu
• locking
• loss
• oltp
• performance
• process
• profiler
• query
• queue
• security
• SQL Server
• trace
• wait

• 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

• 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