Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shiyam198
Yak Posting Veteran
94 Posts |
 Posted - 2013-09-17 : 10:40:52
|
| Hi,We setup Windows Snapshots on the Windows Server (VM) that runs SQL server 2008.It hosts databases for a reporting application. So, 90% of the queries are reads and the rest are writes to a log database.I see significant slowness on this server after I restored the databases on the server. The queries (read) that usually take 1 to 4 seconds now take 35 seconds. I see there is a snapshot setup on this server on the OS (Windows) level. Could this be a reason?Thanks for your input?- Shiyam |
|
|
|
|
|
Windows Snapshot on the DB server