Viewing 4 posts - 1 through 5 (of 5 total)
colin Leversuch-Roberts (2/16/2009)
btw. I'd have 2gb for o/s as totally inadequate - 4Gb maybe, ideally 6GB
why do you sai that? in my case(2GBs reserved for OS) I have total...
February 19, 2009 at 6:06 am
Hi all,
So on another machine the same query that has that wait type runs in 2 mins and on this new machine is running for aprox. 2 hours;
The query is...
February 18, 2009 at 11:45 am
Keep in mind that I'm using 32 bit version on SQL server 2005, and as I know 32 bit version can't use more than 4 GB of memory without using...
February 11, 2009 at 7:40 am
Can you post that query?
I can also check the execution plan and see how the indexes are used.
Dan
April 11, 2007 at 12:41 am
Viewing 4 posts - 1 through 5 (of 5 total)