Viewing 15 posts - 8,626 through 8,640 (of 49,571 total)
The blocked process threshold is not going to catch deadlocks. It's there to report long-term blocking where the blocked session waits longer than the threshold you've configured (5 seconds there)
For...
June 25, 2014 at 3:59 am
If compilations are high, you may want to investigate why cached plans aren't being reused. It's not an automatic 'you are under memory pressure' though.
June 25, 2014 at 3:09 am
Welsh Corgi (6/24/2014)
I dropped the Non Clustered Index and it is in a suspended State and a PAGEIOLATCH_EX Wait Type.Percent Complete steady at zero percent.
Probably because it's waiting for the...
June 24, 2014 at 12:17 pm
Mr. Kapsicum (6/24/2014)
IF the drive where your log file is situated gets full, can't you shrink the Log file to free some space.?
Shrink releases free space in the file...
June 24, 2014 at 12:00 pm
kevinsql7 (6/24/2014)
Just to clarify, I take it that the dbcc shrinkdatabase command does not write to the transaction log.
It's a modification to the database. It is logged. So's shrinkfile. ALL...
June 24, 2014 at 10:20 am
yuvipoy (6/24/2014)
which option to go witha)Reindex DB after huge delete or insert happened
b)Reindex DB and shrink some one month gape
c)Shrink and Reindex DB some 10 month gape
d) Rebuild...
June 24, 2014 at 6:38 am
Please don't do that. Horrible practice.
If you manage the log properly, you won't need to shrink it. Please take a read through http://www.sqlservercentral.com/articles/Administration/64582/
June 24, 2014 at 6:12 am
It removes every single cached plan, So next time the queries run, they have to go through the expensive compilation process again.
It is NOT something that should be run on...
June 24, 2014 at 12:53 am
The majority of the memory usage on an instance is not going to be by the queries, it's going to be the buffer pool, the data cache should be the...
June 23, 2014 at 7:54 am
Start by investigating what changed.
Also bear in mind that a single counter is almost never useful by itself. If the latch waits/sec changes, what else has changed, in what way....
June 23, 2014 at 6:40 am
Lowell (6/23/2014)
looks like you posted actual or peudocode from MySQL, I'm guessing?
It's PHP.
June 23, 2014 at 5:42 am
If they aren't blocking anything, then it should be pretty safe to leave them be. Just watch that there isn't an open tran registered for any of them that could...
June 23, 2014 at 3:37 am
Viewing 15 posts - 8,626 through 8,640 (of 49,571 total)