Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) Blockages In New Production Server RE: Blockages In New Production Server
SQLBuddy123
One Orange Chip
Points: 28294
More actions
March 12, 2014 at 11:31 am
#1696495
Definitely SP2. Are you doing DB maintenance on the new server (Index Rebuilds, Update Stats) ?
And check for the Server level settings (Memory, CPU etc ..). Also try to identify the causes for blocking and capture WAITs too.
--
SQLBuddy