Viewing 15 posts - 11,896 through 11,910 (of 22,219 total)
Well done Gail. The place just wouldn't be the same without you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2011 at 3:24 am
106919046 (9/7/2011)
If your files change alot. I recommend you use incremental backup instead of deferential backup.
Recheck your backup task, see if it did...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2011 at 3:23 am
If the vendor won't support the upgrade, don't do it. Even if you only hit very minor issues, they can disavow all support and you're on your own. If you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 6, 2011 at 5:55 am
Then you shouldn't be surprised if it slows things down. Make sure you're running these processes at the slowest part of the day because they will affect each other. If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 6, 2011 at 5:08 am
ananda.murugesan (9/5/2011)
I understand for IO never become 0.0.
Could you tell me, what is actual value output for most IO query and what is generally perfered value of IO...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 6, 2011 at 5:04 am
Temporary tables will cause the recompile. If the amount of data you're working with is small, say less than 200 rows, you could switch to table variables. These will not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 6, 2011 at 4:55 am
It's not a very big table. Is there lots of contention? Other processes accessing it while you're attempting to defrag? That would explain the slow down.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 6, 2011 at 4:51 am
You can't get zero i/o, ever. You have to have some i/o or you're neither querying or returning any data. So that goal is right out the window.
As far as...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2011 at 8:10 am
There's not enough information here to give you good info. First, the database tuning adviser is a pile of steaming brown stuff. It's recommendations are frequently useless and sometimes dangerous....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2011 at 8:03 am
forsqlserver (9/5/2011)
Just to be included in the answers
You don't have to do that. If you go to the top right of the page with the question on it and click...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2011 at 7:59 am
Backups are largely an I/O operation. How fast are your disks? Are you backing up over the network? Are there contentions on the system? Can you put multiple disks to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2011 at 7:58 am
beejug1983 (9/5/2011)
Only backup job is running at scheduled time.
There has to be something else going on. Has to. SQL Server doesn't just randomly decide to slow down. Are you backing...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 5, 2011 at 7:55 am
GilaMonster (9/4/2011)
Grant Fritchey (9/4/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 4, 2011 at 6:24 am
The question is, what is causing it? What are your queries doing and what is your structure such that you're getting excessive writes? Could something have changed between RTM &...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 4, 2011 at 6:09 am
And having Enterprise wouldn't change the fact that you need to adjust the trace events to collect only the information you need. Nothing magic there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 4, 2011 at 6:07 am
Viewing 15 posts - 11,896 through 11,910 (of 22,219 total)