You are will avoid high number of wait type CXPACKET.

sp_configure 'max degree of parallelism', '1' << set global MAXDOP.

Other thing:

SET CPU affinity mask for SQL Server, uncheck 1 CPU.

Best,

Hi,

Use PAL Tool: http://pal.codeplex.com/

My suggesting is

set:

sp_configure 'max degree of parallelism', '1'

Best,

Hi,

DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages

------ ----------- ----------- ----------- ----------- --------------

7...

To welcome 🙂

More about SQL Server Memory SET: http://www.coeo.com/presentations/Coeo_SQL_Memory.pdf

Best regards,

Michal Marek

Hi,

AWE set only in 32 bit OS + "lock pages in memory".

Best regards,

Michal Marek

Hi

You should set MAX Server memory to... :

a. 2 GB for Windows

b. xGB for SQL Server worker threads (http://www.coeo.com/presentations/Coeo_SQL_Memory.pdf)

c. 1GB for multi-page allocations, linked servers, and other consumers of memory...

Whot is set in "sp_configure" ?

sp_configure 'show advanced options', 1;

GO

RECONFIGURE WITH OVERRIDE;

GO

sp_configure

GO

Yes, we are set for "lock pages in memory".

One question...we have this set via the Domain Admins group which our SQL Service account is part of (not recommended I know)....

In my servers I set half of MAX SQL Server Memory.

When you set "lock pages in memory" (usually set with "AWE" on 32 bit machines) in gpedit.msc, MIN Server...

First question:

Are You set "lock pages in memory" in gpedit.msc for account sqlservices?

Twice:

what are you set RAID for Database, TempDb, Log Files... ? It is for...

Hi

You should allow the following:

a. 2 GB for Windows

b. xGB for SQL Server worker threads (http://www.coeo.com/presentations/Coeo_SQL_Memory.pdf)

c. 1GB for multi-page allocations, linked servers, and other consumers of memory outside the buffer...