Viewing 15 posts - 17,131 through 17,145 (of 19,560 total)
Lynn Pettis (2/18/2010)
[ apologies ]
I'm sorry for the sarcastic comments in the last...
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 18, 2010 at 2:40 pm
GilaMonster (2/18/2010)
Dave Ballantyne (2/18/2010)
If my database were down for that period , we would be losing money hand over fist.
If my former company's primary DB had been down for 24...
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 18, 2010 at 2:37 pm
Lynn Pettis (2/18/2010)
Dave Ballantyne (2/18/2010)
Surely it does have to cease being an emergency after 24hrs.There have been shorter wars.
http://www.sqlservercentral.com/Forums/Topic867521-1550-1.aspx
Next post: How do I prepare for an interview... ...
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 18, 2010 at 2:36 pm
Lynn Pettis (2/18/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
February 18, 2010 at 1:19 pm
Lynn Pettis (2/18/2010)
Let's see what I have: A sporadic blog with not much on it, assisting people here, 4 articles (2 of which were published first on sswug.org and then...
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 18, 2010 at 1:03 pm
Open up performance monitor and select the appropriate disk and cpu counters.
Here is a document from Microsoft on it
http://msdn.microsoft.com/en-us/library/cc966540.aspx
And another article by Grant Fritchey here:
http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/#seventh
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 18, 2010 at 12:52 pm
Barry would be a good person to be an MVP.
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 18, 2010 at 12:47 pm
Congrats on passing the exam.
Please DON'T post anything that will violate the NDA.
However, sharing your opinion/thoughts about the exam (liked it, hated it, difficult, you felt well prepared), is fine...
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 18, 2010 at 12:45 pm
They can run under the Agent service account (default behavior), when run as a scheduled job.
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 18, 2010 at 12:40 pm
Lynn's new signature
Saint Lynn Pettis MVP
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 18, 2010 at 12:36 pm
Heh, leaving early on friday means leaving when everybody else does. It is nice to do so though.
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 18, 2010 at 11:59 am
Those are all data files, right? What is the size of the log file?
And I don't recall, did you have CPU spikes or DISK IO spikes while running this...
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 18, 2010 at 11:56 am
GSquared (2/18/2010)
CirquedeSQLeil (2/18/2010)
GSquared (2/18/2010)
Personally, if I'm ever wrong (it's bound to happen someday), I prefer to just be put in front of a firing squad. 🙂
Would that be the "Shoot-Aim-Ready"...
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 18, 2010 at 11:53 am
double post
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 18, 2010 at 11:50 am
Roy Ernest (2/18/2010)
Lynn Pettis (2/18/2010)
Roy Ernest (2/18/2010)
And when I cause noise you can slap me on the head... :hehe:About the MVP topic, only MVPs can nominate someone...Right?
No, anyone can nominate...
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 18, 2010 at 11:49 am
Viewing 15 posts - 17,131 through 17,145 (of 19,560 total)