The Service Account of your SQL Server.

Set “Lock Pages in Memory”:

Open the Group Policies Console:

START-RUN , enter - gpedit.msc

Computer Configuration - Windows Settings - Security Settings – Local Policies - User Rights Assignment

In the...

TechNet Virtual Labs:

http://msevents.microsoft.com/cui/SearchDisplay.aspx?culture=en-US#culture=en-US;eventType=4;sortKey=;sortOrder=;pageEvent=false;hdnInitialCount=;searchcontrol=yes;kwdAny=SSIS

ooops, my bad. Good call Mohit. Wasn't thinking 64-bit when I wrote.

DBCC Memorystatus may help. It will at least show you how much AWE is currently being used. It's not unusual at all for the os to be using...

All very good points, but you have missed the important question. Have you found your TempDB to be a performance bottleneck?

The current size of TempDB is only 4gig. ...

Perfect ! Thanks so much for all the help.

Thanks very, just what I was looking for.

The email I receive has a lot of blank lines, followed by a lot of dashed-lines, then I get the host name I'm...

DBCC memorystatus

Could run the query through the Database Tuning Advisor just to see what it's recommendation would be.

even for 64-bit, you still need to "lock pages in memory"

Open the Group Policies Console:

START-RUN , enter - gpedit.msc

Computer Configuration - Windows Settings - Security Settings –

-Local...

DBCC MEMORYSTATUS will show awe used.

check SQL SERVER AGENT --> PROPERTIES --> Alert system --> enable mail profile.

I know the "experts" say to have one tempdb data file per core as a "best Practice". I've always personally disagreed with this. The bottom line, it all...

You can create a scheduled job in another sql server on another box. Create a link and then run a simple query like "select count(*) from linkname..sys.sysdatabases;". You...