First time Server is Running Slow:
Check if application is running slow
Check if there was any change in application site
Check if there is anything process is blocked or deadlocked (SP_who2)
Check with SP_Lock
Check if there was any change in windows
Check the memory CPU uses special consideration to be given if the machine is running under VM.
First time in SQL server: Check backup job is set and upon successfully running. what are the databases in the server
Server is down: RDP, Configuration Manager, Cluster manager, application event log, sql error log monitoring tool
Urgent Emergency: Get trusted consultant support, call Microsoft call local partners
Non Urgency: Post question in forums like MSDN/ TechNett without any conf data, #sqlhelp twitter,
Query/ Storeporcedte Tuning : Check execution plan to see if it is doing any table scan, bookmark lookup or RID, review query, sometime removing the index, creating the covering index will help to have seek operation.
Store procedure:
Include set no count on statement
Use schema name with object name
Use if exists instead of select *
Check if its using cursor try to replace it with set based operation or temp table
Keep transaction short as possible
Optimize query and fine tune index
Minimize joins and maximize where clauses
Store procedure:
Include set no count on statement
Use schema name with object name
Use if exists instead of select *
Check if its using cursor try to replace it with set based operation or temp table
Keep transaction short as possible
Optimize query and fine tune index
Minimize joins and maximize where clauses
DBCC check DB, DBCC Check Table, DBCC check Counting, DBCC shrink File, DBCC Input buffer .
SQL Server is not starting: SQL Server error log, Windows server event log, take help with windows team, check if the server was patched or any configuration has been changed.
Slow Performance trouble shoot:
Gather information with help of SQL profiler, System store procedures like sp_who2 etc, Sql Server error Log, windows Server event log, Performance related DMVs third party monitoring tool DMV performance tool, Windows level performance like CPU high Momery use cycle etc.
Analyze and determine the problem, Testing with dev or test , Implement in production with change process.
DBA STORY
Redgate and SQL Server 2008 SP 2 CU 3 not compatible issue
No comments:
Post a Comment