Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to solve buffer latches problem Expand / Collapse
Posted Monday, December 17, 2012 11:16 PM


Group: General Forum Members
Last Login: 2 days ago @ 3:56 PM
Points: 195, Visits: 823
We have database in SQL SERVER 2008.We have 393GB memory on that machine.Today we had lots of performance issues .SQL SERVER was very slow a couple times(each time 5-30 minutes).When I checked the Buffer lacthes was spiking around outage time.I could not find any error(time out) in sql server log.I know that Bhffer latch happens,when proccesses try to updated the same page?How can I find what is causing the buffer latch? How can I fix it?


Post #1397562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse