the easiest way is to open profiler and create a trace using your template.

Then export the trace-settings to a sqlscript.

Add a appropriate filename (see generated script)  and copy/paste it to...

check out http://www.sql-server-performance.com/awe_memory.asp

yes, you are right. Adding the /3Gb should do the trick.

gotchas ? The /3Gb is in the boot.ini so it will need a reboot.

If you do your action on the...

Thanks for the support

Being sysadmin doesn't make you a god after all

indeed, the openrowset may be the "more dynamic" and "let's see what we get" way, but how will it behave regarding performance.

btw in house we are not alowed to use...

I've been to quick with my response using a text column

Aparently text/image operators cannot be used...

same goes for varcharcolumns of 8000

Indeed these kind of constructions will have a cost !

CREATE     FUNCTION [dbo].[fn_ALZDBA_GetFullDescription](@Index int)

RETURNS @tblFullDescription TABLE

 (RefIndex int not...

- did you run DBCC UPDATEUSAGE  ('master') with count_rows 

 followed by sp_updatestats

- I wonder what sp_helpfile returns ?

check out Distribution of Enterprise Manager registrations

maybe applying the Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 will help (or the latest cumulative hotfix 9.00.3161 )

KB 935356

- launch sql profiler and examine your most consuming queries.

- do you have "auto update statistics" activated ?

  if not, did someone run sp_updatestats ?

   changes in stats will...

do your connections use isolation level repeatable read (default for .net) in stead of read committed ?

capture their data in temp-tables (#tmpprocx, #tmpprocy, #tmpprocz) and join these 3 tables.

what virsion and sp of SQLServer are you running ?

to keep them available, but avoid the actual resourceoverhead (ram-wize) just have the databases closed.

alter database xyz set AUTO_CLOSE ON .

Check BOL and remove it from db that get opened frequently !