March 17, 2014 at 8:07 am
when check point run on tempdb, giving following error
Time-out occurred while waiting for buffer latch type 3 for page (5:343016), database ID 2. [SQLSTATE 42000] (Error 845). The step failed.
can any one help out ?
March 17, 2014 at 10:37 am
I'd start by identifying what is holding the lock and why it's holding it. That would be priority one. Is it an uncommitted transaction? Can you commit it? Do you need to kill it (never a good thing and frequently quite dangerous). That would be the first concern.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 17, 2014 at 10:48 am
Do you have read committed snapshot enabled?
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
March 18, 2014 at 8:52 am
no, before it was working fine without changing it
March 19, 2014 at 2:23 am
Check the SQL Server error log at the same to see if you have IO stalled warning or error messages..!
eg: IO taking longer than 15 seconds
January 12, 2016 at 1:26 pm
Yes Read Committed Snapshot is Enabled for My Database. Can you please explain more on that..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply