Pat
  • Member for 5 years, 9 months
  • Last seen more than a week ago
Transactional replication latency issue
Accepted answer
7 votes

I had to finally call Microsoft support and just a simple command called DBCC LOG INFO on publisher revealed a possible root cause. I saw more than 8600 VLFs! and this was the cause of that ...

View answer
Full and differential backups are taking way longer only from one server
Accepted answer
1 votes

Resolved. There was antivirus software trying to scan backup file as it was being created. Once sysadmin fixed it, differential backup finished within minutes as opposed to taking 2-3 hours.

View answer
Queries are performing bad after SQL Server 2008 SP4 upgrade
Accepted answer
0 votes

We opened a support ticket with Microsoft and they gave us a tool to run to gather metrics when issue was in progress. I couldn't run the tool during business hours since I didn't want it cause ...

View answer