Viewing 15 posts - 17,206 through 17,220 (of 19,560 total)
Lynn Pettis (2/17/2010)
Root-eady-ShAim ...
I think that is more appropriate.
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 17, 2010 at 12:27 pm
Alvin Ramard (2/17/2010)
Changing subject for a second.A wise person once told me:
[font="Comic Sans MS"]"Do not argue with a fool. People may not know which one is the fool."[/font]
And...
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 17, 2010 at 12:25 pm
D'oh. Still trying to get all of my sense back after having been timewarped.
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 17, 2010 at 12:24 pm
If it is a crisis and the databases are down, it serves nobody to finger-point. Server Team, Admin Team, SAN Team, and Database Team (occasionally development team) had better...
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 17, 2010 at 12:23 pm
isuckatsql (2/17/2010)
Eight processors
Go ahead and try the query with output to file.
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 17, 2010 at 12:18 pm
snoot
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 17, 2010 at 12:16 pm
jcrawf02 (2/17/2010)
blast-ended skrewt
haha
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 17, 2010 at 12:16 pm
Nice solution Paul.
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 17, 2010 at 11:48 am
george sibbald (2/17/2010)
Steve Jones - Editor (2/17/2010)
Shazam!DBCC Timewarp has timewarped back from yesterday.
still missing the points I think Steve :crying:
I think you are right. I wanted to give it...
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 17, 2010 at 11:39 am
The query provided used a query hint that forces max degree of parallelism for that query only.
Through SSMS, right click the server, select properties from the context menu. Click...
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 17, 2010 at 11:38 am
Alvin Ramard (2/17/2010)
Steve Jones - Editor (2/17/2010)
Shazam!DBCC Timewarp has timewarped back from yesterday.
We're missing the last few posts, but from what I remember, they didn't add much to the useful...
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 17, 2010 at 11:30 am
isuckatsql (2/17/2010)
SQLBOT (2/17/2010)
I do also note that parallelism = "false" in the xml of both. Not 100% sure if it means...
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 17, 2010 at 11:14 am
Thanks for the article.
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 17, 2010 at 11:11 am
Steve Jones - Editor (2/17/2010)
Quick, everyone say a...
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 17, 2010 at 10:50 am
fruit
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 17, 2010 at 10:48 am
Viewing 15 posts - 17,206 through 17,220 (of 19,560 total)