Viewing 2 posts - 61 through 62 (of 62 total)
TempDB has default settings so it is in simple recovery mode already. Logfile is 4MB (sql has not been restarted since the error.)
I was under the impression that main reason...
April 15, 2003 at 10:13 am
#454271
No affinity mask is set. Memory seems fine, 1.5GB - my SQL Buffer Cache Hit Ratio is consistently above 99.9% and pages/sec is very low, averaging about 2 over any...
April 7, 2003 at 5:59 am
#453324