Viewing 15 posts - 6,946 through 6,960 (of 19,560 total)
Jerry
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 1, 2012 at 1:52 pm
Relic
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 1, 2012 at 5:47 am
Maybe somebody will be along later to correct the answer???
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 1, 2012 at 5:25 am
Steve Jones - SSC Editor (1/31/2012)
SQL Kiwi (1/31/2012)
Ok, the embedded quotes occupy a whole screen now...I need a filter to whack multiple embedded quotes. It can be quite annoying.
Wait to...
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
January 31, 2012 at 12:42 pm
JAZZ Master (1/31/2012)
Brandie Tarvin (1/31/2012)
Daniel Bowlin (1/31/2012)
crookj (1/31/2012)
SQLRNNR (1/31/2012)
rockPet
Commodore
Band
Stand
American
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
January 31, 2012 at 12:41 pm
I'd love to go. I hope to be in attendance and maybe see some people there.
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
January 31, 2012 at 10:28 am
rock
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
January 31, 2012 at 8:52 am
Agreed. That is one of the biggest problems with ad-hoc queries. I have a client with a much higher ad-hoc cache than what you are seeing.
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
January 31, 2012 at 8:19 am
They were used at least twice. Anything not used more than once will retain the stub. Upon being used a second time, the stub is replaced with an...
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
January 31, 2012 at 6:46 am
Greg Edwards-268690 (1/31/2012)
Koen Verbeeck (1/31/2012)
Greg Edwards-268690 (1/31/2012)
Must have been the 3rd table that caused the confusion.Book only showed 2 in an example.
😀
Shows what happens when I think - other people...
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
January 31, 2012 at 6:40 am
It sounds like you have a ton of multi-use ad hoc queries, hence minimal 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
January 31, 2012 at 6:38 am
I too see this as more of a tool that will be used for abuse. Then again, there will probably be plenty of happy people entering their data. ...
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
January 31, 2012 at 6:36 am
You replied while I was updating my reply. Check the rest of my last 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
January 31, 2012 at 6:32 am
What is the value for Compiled Plan Stub?
You can still get Cache bloat from ad-hoc plans. It should be less than before. This setting is mainly to help...
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
January 31, 2012 at 6:28 am
It's a mix for me. I sometimes use paper and pen (not pencil) or I will type them electronically on laptop, phone or something - it depends on 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
January 31, 2012 at 6:24 am
Viewing 15 posts - 6,946 through 6,960 (of 19,560 total)