Viewing 15 posts - 9,646 through 9,660 (of 22,224 total)
GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.
No, the same thing, same behaviour, same mechanics.
The...
"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
August 20, 2013 at 9:11 am
GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
"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
August 20, 2013 at 8:20 am
HanShi (8/20/2013)
Grant Fritchey (8/20/2013)
"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
August 20, 2013 at 7:24 am
First question, always, slow as compared to what? You need to understand where to focus your efforts.
Assuming, as Jeff points out, we have indications of a database problem, then move...
"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
August 20, 2013 at 7:19 am
A backup is a page by page copy of the database. A restore is therefore also a page by page copy of the database. There is no way to modify...
"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
August 20, 2013 at 7:07 am
Another option for testing, but only for testing read operations, is to export the statistics from the production database and then import them into your test database. The query optimizer...
"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
August 20, 2013 at 7:05 am
Not that Jeff's answer needs reinforcement, it sure can't hurt to repeat the fact that backing up to a local drive through some automated process (I assuming you're automating your...
"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
August 20, 2013 at 7:03 am
But, by snapshotting to a seperate set of disks and then performing DBCC there, you won't be seeing the physical layout checks run against the original set of disks. 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
August 20, 2013 at 7:00 am
I'd suggest first understanding why you're experiencing the blocking. You can use sys.dm_exec_query_stats to see what is being blocked. Resolving the issues at the query or index/structure level is the...
"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
August 19, 2013 at 1:07 pm
below86 (8/16/2013)
"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
August 16, 2013 at 1:16 pm
calvo (8/16/2013)
"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
August 16, 2013 at 12:37 pm
Paul White (8/15/2013)
Jeff Moden (8/15/2013)
"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
August 16, 2013 at 5:09 am
Everything Gail said.
But, if you do have a problem with a plan in cache (again, nothing to do with tempdb), then it is possible to run DBCC FREEPROCCACHE and pass...
"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
August 15, 2013 at 11:37 am
Shortest possible answer, do your best.
There is no easy way to deal with people who are unreasonable. But, work your communication skills. Develop a tough skin. Do what you can....
"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
August 15, 2013 at 11:33 am
This is a classic, it depends problem. Depending on how you structure the indexes and how your data is being loaded, yes, clustered indexes actually speed up insert operations. But,...
"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
August 15, 2013 at 7:43 am
Viewing 15 posts - 9,646 through 9,660 (of 22,224 total)