Viewing 15 posts - 16,771 through 16,785 (of 19,560 total)
Paul White (3/8/2010)
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
March 8, 2010 at 9:08 am
Roy Ernest (3/8/2010)
But there are lots of developers who wants to do it right. There are only...
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
March 8, 2010 at 9:07 am
Thanks for posting back with your resolution.
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
March 7, 2010 at 8:33 pm
Steve Jones - Editor (3/7/2010)
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
March 7, 2010 at 7:27 pm
Jeff Moden (3/6/2010)
I agree that having tools are good and every DBA should strive to learn as much about them as they can... if, for nothing else, to learn of...
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
March 7, 2010 at 7:26 pm
lmu92 (3/6/2010)
I'm not sure if Database Engine Tuning Advisor should be on that list:
I agree with this assessment. This tool can be useful, and can be very detrimental. ...
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
March 7, 2010 at 7:23 pm
bitbucket-25253 (3/7/2010)
Tom.Thomson
If clear warnings were given at first offence the continued offending should make them comparatively easy to fire.
Used to work for company where the first offense was...
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
March 7, 2010 at 7:07 pm
sameh.hamza (3/7/2010)
We have a SQL server 2005 db which we are going to deploy on customer's server(will be accessed by our application), we need to do the followings:
1- Prevent...
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
March 7, 2010 at 8:34 am
iamthemanx (3/7/2010)
Come to think of it, that would be fun. Certify in Oracle just for the sake of having done it.
what do you mean with "fun" , are 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
March 7, 2010 at 8:30 am
First some reading material on the subject.
http://technet.microsoft.com/en-us/library/cc757854(WS.10).aspx
VSS is used to create a copy/backup of the volume. Thus, when it kicks off, you will see a higher Disk Queue length.
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
March 6, 2010 at 11:30 pm
CHeck out this article on how to disable the service, as well as for some info on the service
http://en.kioskea.net/faq/2679-turning-off-volume-shadow-copy
Another article about the disabling of certain services
http://blogs.msdn.com/adioltean/archive/2004/12/26/332540.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
March 6, 2010 at 11:27 pm
credenza
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
March 6, 2010 at 11:19 pm
Nice article. Thanks for taking the time to write it and share it with us.
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
March 6, 2010 at 11:12 pm
Jeff Moden (3/6/2010)
Heh... nice. Probably a bit difficult to memorize for an interview, though. 😛
That is part of the beauty of this query.
😀
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
March 6, 2010 at 11:08 pm
Whisper9999 (3/6/2010)
Jeff Moden (3/6/2010)
Whisper9999 (3/5/2010)
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
March 6, 2010 at 11:06 pm
Viewing 15 posts - 16,771 through 16,785 (of 19,560 total)