Viewing 15 posts - 14,161 through 14,175 (of 22,232 total)
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
Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit nuts to anyone else?
They're...
"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:42 am
Will lights go off or horns sound or a little HUZZAH sound come out of the speaker for the person who hits 1m?
"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 9:25 am
Viewing 15 posts - 14,161 through 14,175 (of 22,232 total)