R u using some third party Sql tool or Perf Counters or using some query from management studio to get that output or something else? What kind of drives do...

True Steve,

But I was talking about operating system license not SQL license. For e.g. in installing Windows Server 2003, for every installed copy of the server software requires purchase of...

You dont have to run in single user mode when executing above two commands. Single user mode option is used when u r trying to repair the pages. i.e. when...

Run with Physical_only option first. If time to execute this query is not much (around 3 to 4 mins), then u can go for DBCC CHECKDB to get more complete...

Can u Run DBCC CHECKDB on ur database and post the results too?Thanks

I would just guess then if u have SQL 2000 enterprise edition then without AWE enabled u will have maximum of 4 GB memory regardless of what u have set...

u can think of it as, ur company doesnt has money to buy to different boxes(or computer) because it will be more costly due to more license of operating system...

Well, in that case if u have enabled AWE and not set maximum allowed memory for SQL server, then it will take all the memory available on ur system leaving...

Can u attach execution plan for both the queries? Thanks

Install ur SQL Server again on the same machine where u have ur SQL Default instance installed. SQL will detect during the installation process that one instance allready exists and...

So there r no indexes too on these tables?

Do u feel slowness while retrieving records?

How often r those tables Queried?

How many tables r there with this kind of...

Also, test ur backups regulalrly by restoring them so u r not in shock on the day of crash.

You have to save Backup files either Full, Log or Diff backups. If ur backups r being done in default, Backup folder by your maintenance plan then it makes sense...

Is ur operating system 32 bit or 64 bit? On what operating system do you have your SQL installed?Thanks.

Why do u need to Turn on both 3604 and 3605? Both do the same thing 3604 send information to Client (Query analyzer) and the other to Log file. I...