Viewing 3 posts - 1 through 3 (of 3 total)
Have you looked at the execution plan of the query, what type of scan does it use ? Could you also please send I/O statistics.
March 8, 2011 at 3:00 pm
#1296198
Windows Installer 4.5 or later is required for installing SQL Server 2008R2.
Check details of C:\Windows\System32\msi.dll to determine the File Version that you are using.
March 7, 2011 at 1:29 pm
#1295566
Looking at the event logs would be a good place to start. I recommend setting leaving 2GB of RAM for OS and allocating the remaining 2GB of RAM to SQL....
March 7, 2011 at 1:19 pm
#1295560