You can use sp_configure to set max server memory.

sp_configure 'Max server memory', value

reconfigure

As Ps said, 64 bit is not affected by AWE settings. Once you have configured the...

I think what Gail said is correct. You have to use Profiler to identify which all queries are I/O intensive.

Meanwhile if you have page life expectancy going down for...

simply create a variable

declare @DelString varchar(max)

While @@fetch_status =0

@DelString = ',' + @DelString

Fetch next from cursor into Cursor variable

In master execute

select * from sysperfinfo where counter_name like '%Log growth%'

This will give total number of log growths

There is no acceptable number of pages as such. It depends on the environment you have.

SQL server loads a page into memory when its first accessed. Subsequent requests...

Once you take a log backup, Its safe to shrink the log file

Yes you can shrink the file to a fixed size

DBCC SHRINKFILE('filename',SizeInMb)

eg DBCC SHRINKFILE('prodLog',1024)

For future, monitor the log file...

Thanks a lot.

Sorry for late reply

Yes. My counters where for each individual drives. I noticed that the spikes where more frequent...

Yes. I thought that was obvious from Gail's previous post. I just meant...

Rebuilding index will removes index fragmentation. Fragmentation affects performance. Anything you do to speed up your queries...

Anyone?

ALLOW_PAGE_LOCKS can but may not lead you to deadlocks. However if you have a very busy OLTP system, page level locks hits concurrency. But remember, if you disable this there...

DBCC SQLPERF("dmvname",CLEAR)

eg: DBCC SQLPERF("sys.dm_os_latch_stats" , CLEAR)

Congratulations SSC, on this great achievment. Three cheers to all the ppl who are eager to share their knowledge.

How much varied your parameters are?

If it varies a lot, sometimes cached execution plans are not as useful

you can recompile it each time.

But you can tune the query by looking...

You have written the query right. If you want just the client columns use subquery

You can use select distinct client.* also