Viewing 15 posts - 766 through 780 (of 19,560 total)
GilaMonster (10/8/2015)
Jack Corbett (10/8/2015)
WayneS (10/7/2015)
GilaMonster (10/6/2015)
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
October 8, 2015 at 3:39 pm
rodjkidd (10/7/2015)
BrainDonor (10/7/2015)
rodjkidd (10/6/2015)
So for Summit will you get to Seattle in time for the meet and greet / official opening of Summit on the Tuesday night?
It will...
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
October 7, 2015 at 8:47 am
GilaMonster (10/6/2015)
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
October 6, 2015 at 10:52 am
ghoul-ash
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
October 4, 2015 at 11:55 pm
ganache
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
October 4, 2015 at 11:55 pm
Eirikur Eiriksson (10/2/2015)
Lynn Pettis (10/2/2015)
Eirikur Eiriksson (10/2/2015)
Lynn Pettis (10/2/2015)
How do I clear the DMVs without restarting SQL?Why?
😎
Because I don't necessarily want to restart SQL just to clear some of 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
October 2, 2015 at 11:52 pm
GilaMonster (10/2/2015)
chuck.forbes (10/2/2015)
So why are some people suggesting the temporary switch to SIMPLE?
Usually because the people suggesting it don't really know what they're talking about.
Hahaha - so true!
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
October 2, 2015 at 5:58 pm
Stewart "Arturius" Campbell (10/2/2015)
Federations will be retired with Web and Business service tiers in September 2015. (See...
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
October 2, 2015 at 1:49 pm
Steve Jones - SSC Editor (10/2/2015)
SQLRNNR (10/2/2015)
Brandie Tarvin (10/2/2015)
Lynn Pettis (10/2/2015)
How do I clear the DMVs without restarting SQL?
I found this StackOverflow article. Does it help?
DBCC SQLPERF('sys.dmv_name_here',CLEAR);
--EDIT: And then 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
October 2, 2015 at 12:55 pm
Brandie Tarvin (10/2/2015)
SQLRNNR (10/2/2015)
Brandie Tarvin (10/2/2015)
Lynn Pettis (10/2/2015)
How do I clear the DMVs without restarting SQL?
I found this StackOverflow article. Does it help?
DBCC SQLPERF('sys.dmv_name_here',CLEAR);
--EDIT: And then this if clearing plan...
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
October 2, 2015 at 12:54 pm
Brandie Tarvin (10/2/2015)
Lynn Pettis (10/2/2015)
How do I clear the DMVs without restarting SQL?
I found this StackOverflow article. Does it help?
DBCC SQLPERF('sys.dmv_name_here',CLEAR);
--EDIT: And then this if clearing plan cache too
DBCC SQLPERF('sys.dm_exec_cached_plans',...
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
October 2, 2015 at 12:28 pm
Lynn Pettis (10/1/2015)
In my Deadlock thread, was I wrong to admonish the former MVP over his first post? It just hit me wrong.
I thought it was a quick rise...
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
October 2, 2015 at 12:09 am
This is basically the process behind the scenes.
https://technet.microsoft.com/en-us/library/ms175195(v=sql.105).aspx
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
October 1, 2015 at 10:19 pm
Ed Wagner (10/1/2015)
If anyone lives in 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
October 1, 2015 at 10:16 pm
pish
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
October 1, 2015 at 10:15 pm
Viewing 15 posts - 766 through 780 (of 19,560 total)