Viewing 15 posts - 7,231 through 7,245 (of 19,560 total)
SQL Kiwi (1/9/2012)
GSquared (1/9/2012)
Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.
You don't think 'Aaron Aardvark' has...
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 9, 2012 at 10:45 am
GilaMonster (1/9/2012)
SQLRNNR (1/9/2012)
Continue to monitor CMEMTHREAD over time and watch how fast it grows.
CMEMTHREAD is the name of the wait type, not the cache. The cache name 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
January 9, 2012 at 10:40 am
Continue to monitor cache size over time and watch how fast it grows. Keep track of that and you will be able to determine if it is a TokenAndPermUserStore...
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 9, 2012 at 10:25 am
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛I don't set a quantitative target on that.
Just like my naming standard of Caps on Consonants and...
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 9, 2012 at 9:59 am
My opinion - the books are not good for the exam.
If looking to write this exam, it is 100x better to have a lot of experience and to practice as...
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 9, 2012 at 9:53 am
Can you get the package to run outside of the agent 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
January 9, 2012 at 9:45 am
GilaMonster (1/9/2012)
http://sqlinthewild.co.za/index.php/2007/10/21/memory-and-sql-2005-sp2/
http://sqlinthewild.co.za/index.php/2008/05/02/token-and-perm-user-store-growth/
The blog posts are for SQL 2005, but the issue can come up on 2008 as well (just a lot less likely). See if you have the rest 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
January 9, 2012 at 9:35 am
Biggest source is here in these forums. Browse the forums and try to answer the questions.
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 9, 2012 at 9:23 am
Ninja's_RGR'us (1/9/2012)
SQLRNNR (1/9/2012)
Daniel Bowlin (1/9/2012)
Brandie Tarvin (1/9/2012)
GilaMonster (1/8/2012)
SQLRNNR (1/8/2012)
GilaMonster (1/8/2012)
SQLRNNR (1/8/2012)
Revenant (1/8/2012)
MysteryJimbo (1/8/2012)
WirelessBluetooth
Toothless
Dragon!
Night Fury
Cute.
...AND FUZZY! (as Stitch would say).
Don't forget Warm.
Please keep them away from light and water.
TMNT.
Shredder
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 9, 2012 at 9:17 am
Roy Ernest (1/9/2012)
When I get time post some thing,...
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 9, 2012 at 9:12 am
Daniel Bowlin (1/9/2012)
Brandie Tarvin (1/9/2012)
GilaMonster (1/8/2012)
SQLRNNR (1/8/2012)
GilaMonster (1/8/2012)
SQLRNNR (1/8/2012)
Revenant (1/8/2012)
MysteryJimbo (1/8/2012)
WirelessBluetooth
Toothless
Dragon!
Night Fury
Cute.
...AND FUZZY! (as Stitch would say).
Don't forget Warm.
Please keep them away from light and water.
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 9, 2012 at 9:07 am
These scripts are for for current activity.
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 9, 2012 at 9:05 am
Steve Jones - SSC Editor (1/8/2012)
Doh, copied the wrong item.corrected.
Glad to see our complaining was effective;-)
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 8, 2012 at 11:01 pm
@george - fixed 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
January 8, 2012 at 4:29 pm
I'm not sure of the entire reason behind doing all of this with a script component rather than with TSQL. I would lean more towards a sql script 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 8, 2012 at 4:27 pm
Viewing 15 posts - 7,231 through 7,245 (of 19,560 total)