Viewing 15 posts - 5,011 through 5,025 (of 19,560 total)
Thanks - learned something
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 25, 2013 at 10:07 am
Evil Kraig F (2/22/2013)
Anyone around here worked much with Extended Events? It's way out of my scope,...
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 22, 2013 at 5:03 pm
Jeff Moden (2/22/2013)
Grant Fritchey (2/22/2013)
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 22, 2013 at 5:00 pm
Looking at this quickly, I have two observations.
1. I'd look at dumping this to a file as Grant suggested. That can be very useful - it depends. ...
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 22, 2013 at 4:58 pm
It depends. More info would be helpful.
There are several means to create and excel spreadsheet from SQL Server - the best method depends on what your needs are.
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 22, 2013 at 4:51 pm
Brandie Tarvin (2/13/2013)
Grant Fritchey (2/13/2013)
I think we're back to the Roadhouse rule set here. Be nice.And always keep a set of spare tires in the trunk.
SO long as it is...
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 22, 2013 at 4:45 pm
fercasas (2/19/2013)
Very good article Jason, I will use it to monitor the growth of the tempdb database.
I have a question, for my case should only change the line SET @...
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 19, 2013 at 11:31 am
Nice question. Thanks
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 15, 2013 at 4:52 pm
Thanks for the question
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 15, 2013 at 4:51 pm
sipas (2/13/2013)
It doesn't matter what time zone you are actually currently in, for the purposes of this question it is implied that you are in UTC+05:30.
Unless you know the person...
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 13, 2013 at 7:06 am
bitbucket-25253 (2/11/2013)
Now my question to you: Is the company sponsored employee & spouse/partner formal dinner and dance, a benefit...
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 11, 2013 at 11:28 pm
Silly question, but you have a full backup in place right?
When the backup is running, have you tried watching the folder (in progress) to see if the file even starts...
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 10, 2013 at 7:15 pm
dwain.c (2/10/2013)
SQLRNNR (2/10/2013)
L' Eomot Inversé (2/8/2013)
Lynn Pettis (2/8/2013)
Revenant (2/8/2013)
Lynn Pettis (2/8/2013)
Am I (shudder) an idiot?No. Is there anything that make you think you are?
🙂
Not really, other than having someone call...
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 10, 2013 at 6:55 pm
Can you provide the backup command being issued?
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 10, 2013 at 6:46 pm
GilaMonster (2/10/2013)
Rum a load test of your app, see how large TempDB gets. Set default size to slightly larger.
Same thing I do. Other option is to run it for...
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 10, 2013 at 6:39 pm
Viewing 15 posts - 5,011 through 5,025 (of 19,560 total)