Viewing 15 posts - 1 through 15 (of 33 total)
Check to see if there is any other activity on Sunday, for example, are there backups going on at the same time?
May 25, 2014 at 8:17 am
Based on time you've identified - attempt to track down the main symptoms - which appear to be high CPU. use this information to find other pottential root causes, ...
May 12, 2014 at 11:49 pm
As mentioned - there are plenty of different layers , possible reasons - I/O subsystem problems,I/O subsystem misconfiguration,Fragmentation,Excessive I/O requested by SQL Server,Inefficient placement of data files on disk
From SQL...
March 4, 2014 at 2:08 pm
As an immediate workaround you could increase the timeout .
But investigate the underlying reason why the tomeout occurs - for example are there resource issues which causes the query...
February 15, 2014 at 1:47 am
As well as all suggestions made above, commit some daily checks on SQL Server Error logs - and check if anything unusual appears woth investigating.
July 2, 2013 at 11:36 pm
Here is a post for a definition of query tuning - What is SQL Server Tuning? but in reality query tuning and database tuning in general requires solid knowledge across...
June 5, 2013 at 11:47 pm
When I see Sort warnings - I check a) Statistics are up to date b) Consider Query Tuning
May 25, 2013 at 11:38 pm
Are you receiving any Sort warnings? these can be a clue of ORDER BY spilling into TempDB and insufficient memory. Check Statistics are up to date
May 23, 2013 at 11:48 pm
Common causes include insufficient memory, large temporary tables,large queries silling into TempDB. use queries on Monitor TempDB usage or if you want to list...
May 20, 2013 at 7:12 am
SQL is the the programming language used to manage relational database systems. Regardless of the datbase server system - there is normally a DML and DDL aspects to the...
May 13, 2013 at 3:18 pm
@jeff - "short cuts" , in this context means : a) Increasing time pressure on the Production DBA with limited time to plan and apply principles adequately. ...
January 6, 2013 at 11:52 pm
Good article. The DBA job is significantly easier in the long run , if discipline and sound priniples are applied.
Many DBAs are pragmatic - i.e they work in a...
January 6, 2013 at 10:26 am
Troubleshooting these situations can be tricky, particuarly if processes are running based on business need - without the proper capacity planning exercise.
1) What does the daily upload include, can this...
November 17, 2012 at 9:22 am
The first step is to restore the Differential Base i.e the initial full backup with no recovery, then continue with the Differential.
To identify the relevant files via LSN numbers use...
November 11, 2012 at 12:23 am
One method to use is to study the Execution Plans of the queries .Analyse the code - for example, is it forcing a table scan - where that may not...
November 2, 2012 at 9:16 am
Viewing 15 posts - 1 through 15 (of 33 total)