Viewing 15 posts - 17,266 through 17,280 (of 19,560 total)
Here is a reference about disk alignment. SQL server likes the disks aligned and the cluster sizes to be larger than the default settings.
http://msdn.microsoft.com/en-us/library/dd758814.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 3:48 pm
tstaker (2/16/2010)
@Alvin, Reminds me of what we call the person that Graduated last in Medical school.... Dr.
And the one that Flunked out is DDS
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 3:41 pm
RBarryYoung (2/16/2010)
Steve Cullen (2/16/2010)
It's just a jump to the left. And then a step to the right. 😛Put your hands on your hips?
And shake 'em all about.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 3:27 pm
Now he appears to be backing off a little bit. See his latest.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 3:26 pm
I don't get the impression that he is backing down at all from his position. He says he agrees, but I don't get the impression that he truly does...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 3:19 pm
GT-897544 (2/16/2010)
Elliott W (2/16/2010)
...CEWII
I don't have 15 - 20 years as you guys do. If the Disk is offline Server team had notified the DBA's in first place. If you...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 3:05 pm
Lynn Pettis (2/16/2010)
Alvin Ramard (2/16/2010)
FYI, we still have not heard anything from the OP.He's probably sitting on the sidelines saying WTF?
He probably is.
I couldn't resist at the point of the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:54 pm
Elliott W (2/16/2010)
Bru Medishetty (2/16/2010)
Now Gail's got an Interview question from the poster.
I think I do too, I'm writing that down..
That whole chain made me laugh.. I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:52 pm
If one reacts and shoots from the hips, troubleshooting will become more complicated.
Find out the cause first. Fix the root cause. Troubleshooting is a progression of fact finding...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:50 pm
Ok - it is now real interesting. Referencing Paul Randal's blog on corrupt databases. I think that thread is turning for the south.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:33 pm
He is insistent on the data extraction.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:13 pm
Alvin Ramard (2/16/2010)
CirquedeSQLeil (2/16/2010)
Lynn Pettis (2/16/2010)
How about a different rant. Don't you get tired of answers that really don't help?
Gail just responded to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:11 pm
Chad Crawford (2/16/2010)
BTW - Jason, did you know that our resumes cross? We were at UBS at the same time, but I think in different offices...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 2:10 pm
Lynn Pettis (2/16/2010)
How about a different rant. Don't you get tired of answers that really don't help?
Gail just responded to the suspect thread....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 1:41 pm
I would give that a shot.
Also, out of curiosity. I know the disk subsystem is better on the server. Is it a san or locally attached disks? ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 1:36 pm
Viewing 15 posts - 17,266 through 17,280 (of 19,560 total)