Viewing 15 posts - 16,621 through 16,635 (of 22,226 total)
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Thanks. I was told the max number was 435. I only saw...
"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 2, 2009 at 8:56 am
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?
Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage...
"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 2, 2009 at 8:45 am
Jack Corbett (9/2/2009)
Steve Jones - Editor (9/2/2009)
GilaMonster (9/2/2009)
Nah. Forgotten about it already.She says that Jack, but let's see if she invites you to train on Tues or Wed night ...
I'll...
"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 2, 2009 at 7:59 am
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.
Thanks. I was told the max number was 435. I only saw 410. Still, that'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
September 2, 2009 at 7:38 am
GilaMonster (9/2/2009)
Hey Grant.I completely disagree with your choice of disk counter. Just so you know. 😉
Please, disagree away. I just tried the find the bare bones basic counters. I...
"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 2, 2009 at 7:37 am
Alvin Ramard (9/2/2009)
Jack Corbett (9/2/2009)
Now whenever I read one of your posts I'll have the correct voice in my head:-P
Next up for me...
"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 2, 2009 at 7:36 am
Jack Corbett (9/2/2009)
Enjoying Gail's session on indexing on 24 hours of PASS. Don't know how much I'll retain being up this early.
I'm definately getting the download on that one.
"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 2, 2009 at 7:34 am
nigel (9/2/2009)
Grant even said in his post that it wasn't the greatest approach.
I would avoid recursive CTEs if there is a more...
"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 2, 2009 at 7:32 am
GilaMonster (9/1/2009)
Alvin Ramard (9/1/2009)
24 Hours of PASS starts today and I did not get a good night's sleep last night. It's gonna be a fun 2 days.
Starts tomorrow for...
"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 1, 2009 at 7:41 pm
Krasavita (9/1/2009)
When I ran the query,it wasn't running slow
Ah, well, that's why there wasn't any useful information in the query. You need to gather the information when the slow performance...
"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 1, 2009 at 6:50 am
Yeah, if the procedure kicks out an error, the job should have an On Error statement that determines what to do.
"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 1, 2009 at 6:06 am
Rollback is necessary for SQL Server to preserve the integrity of the database. You don't want it to just leave a bunch of half-saved records hanging out in a database...
"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 1, 2009 at 6:02 am
Krasavita (8/31/2009)
Here is my results.What should I look for?
Looking at that data, I don't see anything running especially slowly. There are no blocked processes. Are you sure that the server...
"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 1, 2009 at 5:58 am
Better than sp_who2, take a look at the DMV sys.dm_exec_requests. That will show you currently running queries. You can combine it with other DMV/DMF to arrive at the query being...
"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 1, 2009 at 5:53 am
You can put a RAISERROR statement within the CATCH statement of your error handler so that, assuming the error needs to be returned, you can raise it and it will...
"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 1, 2009 at 5:51 am
Viewing 15 posts - 16,621 through 16,635 (of 22,226 total)