Viewing 15 posts - 8,626 through 8,640 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 3:09 am
http://www.sqlservercentral.com/articles/Administration/64582/
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 1:16 am
Do log backups more often.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 12:23 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2014 at 12:53 am
Yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2014 at 1:23 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2014 at 3:37 am
Viewing 15 posts - 8,626 through 8,640 (of 49,552 total)