Viewing 15 posts - 12,751 through 12,765 (of 22,224 total)
I just want to reiterate and reinforce one statement. Hints are a last resort. You need to do every other method of tuning before you get to hints. Not only...
"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
April 14, 2011 at 7:42 am
No way I would run any kind of load generation tool against a live production server, regardless of circumstance on the monitoring.
Have you looked at wait stats? You can start...
"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
April 14, 2011 at 7:24 am
Just remember that auto-growth is a safety valve, not a management plan. You should set the database to be bigger than it needs to be and then monitor the space...
"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
April 14, 2011 at 7:23 am
It sure sounds like contention. Next time it's running slow, start with sys.dm_exec_requests and see what the process is waiting on and if it's blocked. You can proceed from 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
April 14, 2011 at 7:21 am
I wouldn't go down to a single file or filegroup on the new system. 5 seems like overkill, but I'd still have at least 2.
"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
April 14, 2011 at 7:19 am
This is just a SWAG, but do you have a system backup that runs that might be locking files? We ran into a similar issue when our system backup would...
"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
April 14, 2011 at 7:18 am
GilaMonster (4/14/2011)
Grant Fritchey (4/14/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
April 14, 2011 at 6:20 am
Craig Farrell (4/14/2011)
I'm going to assume I'm just too...
"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
April 14, 2011 at 6:08 am
mohammed moinudheen (4/14/2011)
I have seen many job postings which requires people knowledgebale in...
"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
April 14, 2011 at 6:04 am
Nice article Craig. The company I left put up a SQL Superman job to try to replace me, despite my protests. My old boss just kept saying "Let's see what...
"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
April 14, 2011 at 6:01 am
GilaMonster (4/14/2011)
fname lname-1111520 (4/14/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
April 14, 2011 at 5:58 am
Craig Farrell (4/13/2011)
Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest of you, too?
There's...
"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
April 13, 2011 at 12:21 pm
ChrisM@home (4/13/2011)
CirquedeSQLeil (4/13/2011)
Grant Fritchey (4/13/2011)
Teh Gila Monster has teh big scares on me and makes me afeared fer me woefully inadequate sexual equipment.*cough*
That should help.
Don't you have to turn 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
April 13, 2011 at 12:15 pm
ChrisM@home (4/13/2011)
Grant Fritchey (4/13/2011)
ChrisM@home (4/13/2011)
varun.dubey29 (4/13/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
April 13, 2011 at 12:14 pm
Timothy Straub (4/13/2011)
Thanks for the info and yes I am testing the performance of a query. I was hoping to be able to test a separate DB...
"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
April 13, 2011 at 10:06 am
Viewing 15 posts - 12,751 through 12,765 (of 22,224 total)