Litespeed also one such tool

R u using IIS , web based application , Connection pooling might be one reason for it. Refer BOL for Orphaned sessions

If u feel memory is the main deal ,...

Just a word to this discussion , run this query select * from ::fn_trace_getinfo(0) and find out how many trace files are running .If only the default audit , try...

If detach/attach or backup/restore after completion - check for mismatch and orphan ids fix it , Default database might also have changed if database is moved to another location ....

In windows authentication mode , sa has no role since its a SQL level id , better install it using Mixed mode and change the authentication mode in case of...

Is there any way to grant alter trace permission for SQL server 2000 box rather than giving sysadmin permission ?

Do u have any script to shrink log files for Mirrored db its huge around 500GB without breaking mirroring .

try running the query if u have still doubt

restore verifyonly from disk=' ' which will provide the details backup file consistancy

8GB physical RAM

This issue is resolved - following steps taken

1.AWE enabled

2.RAID levels checked

3.SQL server maximum memory setting changed to more value(like 5Gb) with /3GB and /PAE.

4.Max degree of parallelism brought to...

If its a DB backup of MSSQL server then you can try installing litespeed quest software which performs well in compressing the backup files - This is a permanent solution...

Hi ,

Do u have both servers in same location , then you can try hard disk movement between two server if its feasible - ( like server is not...

Hi ,

I had the same issue with SQL server agent (SQL server 2000 - Windows 2000 server), drilled down the problem in folders ,registry and dlls ,found SQL server startup...

Hi ,

I am also getting same error . I have checked all privileges for startup account in registry as well as folder level but no clue.Tried running regmon to...

I tried restoring the database from PROD to backup server which is having similar setup,there site performance is good no issues found,after rebooting the server also sleeping does not get...