108 reputation
3
bio website
location
age
visits member for 1 year, 5 months
seen Dec 20 '12 at 16:46

Dec
12
comment Resuming Replication w/ Database Mirroring when Principle is unavailable
Since you have three servers at your disposal, have you tried setting up mirroring in synchronous mode with a witness? If you do this combination with replication, your subscriptions will continue to work automatically after the publisher fails over.
Dec
12
awarded  Editor
Dec
12
revised Why is my database stuck in the Restoring state?
typo - I wrote snapshot, but I meant original database
Dec
12
comment Why is my database stuck in the Restoring state?
Whoops, that was a typo. I meant against the original database. Thanks for the catch, I'll edit that now.
Dec
12
comment why is io_stall_writes_ms so much higher for tempdb?
@Mark - Thank you for the clarification. I appreciate the feedback.
Dec
12
answered Why is my database stuck in the Restoring state?
Dec
11
answered why is io_stall_writes_ms so much higher for tempdb?
Dec
5
comment How to determine the read / write ratio of your server?
You pretty much answered your own question. You might also look at sys.dm_os_buffer_descriptors to see how dirty each database is in memory. That will also give you an idea of where the action is.
Nov
28
answered How to balance SQL Server memory with SQL Server Analysis Services memory
Nov
28
answered Query Linked Server Logins
Nov
14
answered tempdb usage in SQL Server
Nov
2
comment Restore Backup Fails - File 'Db' cannot be restored to '{…}.mdf'. Use WITH MOVE to identify a valid location for the file
Cool, I'm glad it worked!
Nov
2
awarded  Supporter
Nov
2
awarded  Teacher
Nov
2
answered Restore Backup Fails - File 'Db' cannot be restored to '{…}.mdf'. Use WITH MOVE to identify a valid location for the file