Viewing 15 posts - 14,146 through 14,160 (of 22,219 total)
I'd look at the other wait states and queues on the system. You know you're getting lots of disk i/o's, but why? You need to figure out what is causing...
"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
October 7, 2010 at 6:48 am
Without the execution plan it's just guess work to what's going on. Remember, just because you see an index referred to in the execution plan doesn't mean it's being used...
"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
October 7, 2010 at 6:45 am
Basically, I'd rely on perfmon for those metrics. It's should be gathering what you need.
The real question is, what are you trying to figure out? What's happening on 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
October 7, 2010 at 6:42 am
Regularly running at 50-80ms for page life isn't good. I'd look to see if you're getting good plan reuse, are you getting lots of recompiles? I'd also take a look...
"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
October 7, 2010 at 6:40 am
Because one of those errors is dependent on resolution of action, it's not caught by the TRY/CATCH. It's explained here.
"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
October 7, 2010 at 6:36 am
That's a server level query. The security setting on it is View Server State, not View Database State. So it includes the DB_ID so that you can filter for a...
"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
October 7, 2010 at 6:32 am
barry.smallman (10/7/2010)
Yes, I tried amending the SP to query the sys.dm_exec_connections DMV as suggested in the reply by Lowell!!
When the stored procedure failed to run this morning, I started investigating...
"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
October 7, 2010 at 5:31 am
CirquedeSQLeil (10/6/2010)
Grant Fritchey (10/6/2010)
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/2010)
Alvin Ramard (10/6/2010)
Are we there yet?
See what I miss by trying to have a life & stuff. Gotta stop doing things away from...
"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
October 6, 2010 at 8:09 pm
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/2010)
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/2010)
Alvin Ramard (10/6/2010)
Are we there yet?
See what I miss by trying to have a life & stuff. Gotta stop doing things away...
"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
October 6, 2010 at 8:09 pm
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/2010)
Alvin Ramard (10/6/2010)
Are we there yet?See what I miss by trying to have a life & stuff. Gotta stop doing things away from The Thread.
There's life...
"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
October 6, 2010 at 7:26 pm
Alvin Ramard (10/6/2010)
Are we there yet?
See what I miss by trying to have a life & stuff. Gotta stop doing things away from The Thread.
"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
October 6, 2010 at 7:22 pm
Steve Jones - SSC Editor (10/6/2010)
Grant Fritchey (10/6/2010)
"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
October 6, 2010 at 7:16 pm
Alvin Ramard (10/6/2010)
Steve Jones - SSC Editor (10/6/2010)
Well, it wasn't me, Jeff, or Gail. It was Alvin that hit it, so congrats.
Thanks. I'm still in shock. I can't...
"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
October 6, 2010 at 7:14 pm
Alvin Ramard (10/6/2010)
Celebration time!!!!! 😀
And another celebration in about 250 posts as we pass 1,000,000 on the counter.
"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
October 6, 2010 at 11:55 am
Alvin Ramard (10/6/2010)
Grant Fritchey (10/6/2010)
"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
October 6, 2010 at 11:54 am
Viewing 15 posts - 14,146 through 14,160 (of 22,219 total)