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?
I don't know anything about Windows snapshots, but I would take a step back. Have you checked the execution plan? Have you updated statistics on the tables? Is there a hardware bottleneck such as CPU or I/O? What do the wait stats show?