The easiest way probably is to run the sp_who2 in QA and see who is blocking. You can then dbbcc inputbuffer (spid) to see what they are running.

You can also...

You need to upgrade to Ent Edition for it to use more than 2GB of RAM

If you need to capture queries, use profiler and save it to either a file or a table and then you can analyz it when your ready to

Joe, you dont think it would be a good idea to just post the whole thing here ...

...

Is it possible one of your datafiles or log file has reached its max size ?

If so :

1. Execute sp_resetstatus.
2. Use ALTER DATABASE to add a data file or log file...

This is just lazy....

SQL Server 7 Enterprise Edition supports up to 3GB

Set it to single user mode.

RESTORE DATABASE MyDB

FROM DISK = 'C:\MSSQL\Backup\MyDB_Backup.BAK' -- location of backup

WITH MOVE 'MyDB_Data' TO 'C:\MSSQL\Data\MyDB_Data.MDF' -- if location of files is different...

Mac: OS 9 & OS-X

PC: WIN 95, XP-Pro, Server 2000, Server 2003

Unix - Sun Solaris 6.2

My 2c worth, I was a memebr of the SS-SIG in Perth but I left after it started to go way off topic, and well was of no real interest to...

Lets see, 2 Mac's a G3 and a G4 both used for graphic Design. A PC (XP-Pro )with 5 instances of VMWare running, one XP-Pro one Server 2003 as a web server...

I gathered all of that, but what I am after is what could be the cause of the high networkio if the server has gigabit links running as do the...

SQL Server has full access and I am using spotlight in prod with zero issues. Only seems to be here. But then I have removed the builtin/administrator from here...which could...

Thanks for the insight....I guess I will be going with a UDF.

Thanks for that..nice little script. It seems that the public role has all the required permissions. However unless I explicitly grant them to the user, they do not have access...