Viewing 15 posts - 781 through 795 (of 19,560 total)
To recap:
1. Profiler filter issue resolved. You see the deadlocks there now.
2. No indexed views
3. Tuning the code is far from feasible currently.
4. Tracking down how the app accesses 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 3:30 pm
Lynn Pettis (10/1/2015)
Anyone have any idea why Profiler wouldn't capture the deadlock graph even when it was the only thing being captured?
The beauty of filters with profiler. You already found...
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 3:26 pm
Ed Wagner (9/30/2015)
Brandie Tarvin (9/30/2015)
SQLRNNR (9/30/2015)
Eirikur Eiriksson (9/30/2015)
WayneS (9/30/2015)
Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/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
September 30, 2015 at 3:17 pm
Eirikur Eiriksson (9/30/2015)
WayneS (9/30/2015)
Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/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
September 30, 2015 at 12:44 pm
He shouldn't have unplugged the server so he could plug in his vacuum.
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
September 30, 2015 at 9:53 am
Eirikur Eiriksson (9/29/2015)
Ed Wagner (9/29/2015)
djj (9/29/2015)
Ed Wagner (9/29/2015)
DonlSimpson (9/29/2015)
Eirikur Eiriksson (9/29/2015)
HairFollicle
Shave
Close
Encounter
Event
Extended
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
September 30, 2015 at 9:38 am
Hugo Kornelis (9/30/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
September 30, 2015 at 8:52 am
Ed Wagner (9/30/2015)
rodjkidd (9/30/2015)
ChrisM@Work (9/30/2015)
Alvin Ramard (9/30/2015)
Brandie Tarvin (9/30/2015)
Alvin Ramard (9/30/2015)
HARD: Another 4 letter word. 😉Hush, you! 😛
Oh wait! Not all four letter words are bad!
Cold Beer: Two...
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
September 30, 2015 at 8:48 am
mw112009 (9/29/2015)
Can you tell me how to get to this setting ?( I mean how to navigate there )
https://msdn.microsoft.com/en-us/library/ms178067(v=sql.100).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
September 29, 2015 at 8:30 am
robinwilson (9/28/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
September 29, 2015 at 8:23 am
Here are the max supported configs by edition for SQL Server 2008:
https://msdn.microsoft.com/en-us/library/ms143685(v=sql.100).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
September 29, 2015 at 8:09 am
DonlSimpson (9/28/2015)
Ed Wagner (9/28/2015)
whereisSQL? (9/28/2015)
djj (9/28/2015)
Ed Wagner (9/28/2015)
anthony.green (9/28/2015)
ZZartin (9/28/2015)
LeafHeap
Cluster
Single
Engaged
Active
Passive
Node
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
September 28, 2015 at 8:30 pm
TomThomson (9/27/2015)
Nice simple question.Of course branching is the easy bit. Merging the branches is harder. 😀
If it is gonna be called branching, why couldn't they use grafting in lieu...
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
September 28, 2015 at 11:20 am
Eric M Russell (9/28/2015)
it's probably cleaner to not even let them login during the maintenance window.
Agreed.
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
September 28, 2015 at 8:42 am
Ed Wagner (9/25/2015)
Luis Cazares (9/25/2015)
Ed Wagner (9/25/2015)
BrothersMario
Luigi
Koopa
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
September 26, 2015 at 10:38 pm
Viewing 15 posts - 781 through 795 (of 19,560 total)