Viewing 15 posts - 2,281 through 2,295 (of 9,703 total)
Wow. That is good information to have. Thanks for the update, Lynn. I'd never have considered something like that.
October 9, 2015 at 4:58 am
GilaMonster (10/6/2015)
October 6, 2015 at 12:07 pm
Nevermind. I think I found it. Someone hid a database trigger in our DB.
Why it doesn't cause the same issue on other non-prod SQL 2008 environments, I have no...
October 5, 2015 at 11:31 am
Nevermind.
Stupid database trigger crap. grumble mumble.
October 5, 2015 at 11:26 am
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 cache too
DBCC...
October 2, 2015 at 12:31 pm
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', CLEAR);
October 2, 2015 at 11:13 am
Stupid question, which may or may not have anything to do with this...
You mention it starts when 6 ore more users are logged in. Is the program utilizing linked...
October 2, 2015 at 6:29 am
ChrisM@Work (10/2/2015)
Brandie Tarvin (10/2/2015)
Greg Edwards-268690 (10/1/2015)
Brandie Tarvin (10/1/2015)
BrainDonor (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I've been to Canada more times than I can recall...
October 2, 2015 at 6:22 am
Greg Edwards-268690 (10/1/2015)
Brandie Tarvin (10/1/2015)
BrainDonor (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I've been to Canada more times than I can recall - maple with...
October 2, 2015 at 6:07 am
BrainDonor (10/1/2015)
BL0B_EATER (10/1/2015)
Talking about pork products, any one understand Sausage with Maple? I don't..
I've been to Canada more times than I can recall - maple with pretty much anything. Maple...
October 1, 2015 at 4:51 am
GilaMonster (10/1/2015)
Post the deadlock graph and involved queries? I can't recall having needed to dig into the lock hash values to debug deadlocks before.
Maybe Lynn just likes to torture himself....
October 1, 2015 at 4:50 am
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)
September 30, 2015 at 1:20 pm
#headdesk
It's one of those days where I'm throwing spitballs at the wall to see what sticks (to fix a connection issue) and suddenly it's like "Oh, really? It's that one...
September 30, 2015 at 8:17 am
Emil B (9/30/2015)
Brandie Tarvin (9/30/2015)
...Are you using the monitoring tables for anything? Do you have jobs set up that reference them?
After I read this statement i realized that another DBA...
September 30, 2015 at 7:56 am
Alvin Ramard (9/30/2015)
HARD: Another 4 letter word. 😉
Hush, you! 😛
September 30, 2015 at 7:54 am
Viewing 15 posts - 2,281 through 2,295 (of 9,703 total)