meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 6 months |
| seen | Dec 20 '12 at 16:46 | |
| stats | profile views | 5 |
|
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 |
