I HIGHLY recommend you stop using maintenance plans to do your sql server maintenance. Go to ola.hallengren.com and use the suite of scripts and jobs (FREE) found there. ...

Assuming the sql server relational engine is the only thing running on the server I would try 7GB as max memory and monitor for significant paging and memory pressure indications....

1) forums are for targeted, usually straight-forward questions or problems. Your post is neither. You cannot possibly expect to get all the information you request via a forum...

sjimmo (3/15/2011)

---

The /3GB switch is not set. The locking is occuring during the weekly load which is performed using an openrowset from various other servers. Once we are through the...

My gut tells me that something unusual is going on for a DW to be consuming so many locks. Normally (in my experience) DW queries take few high-level locks....

You can find scripts online to do what you want although they are not guaranteed to catch every single object/column/etc. But AFAIK this action is UNSUPPORTED BY MICROSOFT. ...

once you find out what is NOT being done, go to ola.hallengren.com and start to use the awesome FREE database maintenance scripts there to handle all your MX needs, including...

Bristolred (3/11/2011)

---

Hi

I need some help on the best setup with the following:

We have a Microsoft Windows Server 2003 Enterprise Edition Service Pack 2 (18GB Ram) running 1 instance of Microsoft...

sjimmo (3/11/2011)

---

I understand that when the number of locks obtained is equal to 40% of the total SQL Server memory that it will start throwing 1204 errors.

What I am...

1) reread all the requirements for using DTA to do what you want it to do. you may have missed something

2) a full day's profiler run on a busy...

sqldba_icon (3/10/2011)

---

TheSQLGuru (3/10/2011)

---

First-execution times being slow is almost certainly due to simply reading data from disk. After that you are hitting data directly in RAM, which is way faster....

I know of a company that ceased to exist because they lost information due to mis-coded triggers like you have. It is a scarily common problem with trigger code!!...

1) if restored-to server is upgraded version, MUST update ALL stats with FULLSCAN

2) Is restored-to server exactly as capable as original server, and without additional load on it?

3) have you...

1) check network bandwidth with proper tool or even a simple file transfer as someone else mentioned

2) run a query that outputs same data directly to a local file to...

First-execution times being slow is almost certainly due to simply reading data from disk. After that you are hitting data directly in RAM, which is way faster.

Issues...