Viewing 15 posts - 13,531 through 13,545 (of 19,560 total)
David Lu (6/17/2010)
It works very well for me. It is in prod now, after running on QA.
It almost covers everything I need to know, just one more:
Is 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
June 17, 2010 at 11:50 pm
René Scharfe (6/15/2010)
The final bit about this procedure involves the input parameters. I chose to use TinyInts for these fields to permit a value...
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
June 17, 2010 at 11:47 pm
John Cuthbertson (6/17/2010)
Sorry Adam, not Andrew!I isolated the problem thread and it displays Ok with Adam's code.
<?query --
FETCH API_CURSOR000000000002BC4F
--?>
Thanks for the feed back. I will have to look at...
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
June 17, 2010 at 11:45 pm
tosscrosby (6/17/2010)
Mine's bigger! :w00t:
I've got the biggest balls of them all (ACDC lyrics).
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
June 17, 2010 at 2:14 pm
jcrawf02 (6/17/2010)
Chris Morris-439714 (6/17/2010)
jcrawf02 (6/17/2010)
Chris Morris-439714 (6/17/2010)
Before Sing4you whines "Not Yet" and Jason protests "Wasn't me!", this is about football and not pregnancy, right? 😀You mean Hand-Egg?
Jon, you always lower...
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
June 17, 2010 at 11:31 am
I would take the issue to the person above the CIO or equivalent HR department. Be very explicit and get the request for a review documented (at the very...
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
June 17, 2010 at 11:30 am
SpaceBalls
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
June 17, 2010 at 10:46 am
MAK-1128556 (6/17/2010)
I do not mind the growth, but want to shrink the log file, that is not happening
If you shrink it, it will just grow again. That can be...
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
June 17, 2010 at 10:11 am
Sounds like you have a runaway process.
If there is that much transaction occurring in your database, you should consider implementing Full Backups.
Also, you need to find the process causing such...
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
June 17, 2010 at 9:11 am
If the data truly is archive data, then my immediate assumption would be that the data is on a different SLA than the rest of the database(s). If 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
June 17, 2010 at 8:48 am
tosscrosby (6/17/2010)
Chris Morris-439714 (6/17/2010)
Robocat.Robocop - I think that earned something like 12 Oscars!!!
Robocop II
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
June 17, 2010 at 8:38 am
Nice article Elliott. It was a pleasure to read.
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
June 17, 2010 at 12:04 am
Straightforward simple 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
June 16, 2010 at 11:57 pm
Good chuckle.
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
June 16, 2010 at 11:55 pm
Thanks Ron 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
June 16, 2010 at 9:55 pm
Viewing 15 posts - 13,531 through 13,545 (of 19,560 total)