First thing MS will ask you is :

- What SP level are you on ? (sp4 is the current)

- did you apply any hotfixes ?

If you are not on...

- run a trace to see what's going on.

(you can schedule a...

- 10% of 2.6Gb +-260Mb so that explains the file growth

- of that 260Mb (available after auto growth) you have already consumed (260-139) 121Mb.

No problem.

here's a nice overview ...

http://www.sqlservercentral.com/articles/63472/

http://www.codeproject.com/KB/database/SQP_performance.aspx

http://www.mssqltips.com/tip.asp?tip=1556

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

Written by yours truly :w00t:

I guess I lost track of this forum thread I'd launched myself.

Thanks for adding the link.

hth

This is not a challenge.

The point always is to find a thingy that works, alligned with what's reasonable, and...

Yuckon (7/25/2008)

---

Thanks for your suggestion,

DB Mirroring is not an option as I dont want the overhead on Server A - the load must be totally offline.

The reason I want to...

- Wouldn't you be better off setting up db-mirroring ?

(maybe even using db-snapshots to use the data you want)

It will keep up with the updates if...

I'm in Toronto this week spending some quality time with the family :w00t:

I'll see if I can get the info you requested.

Johan

BTW the new drivers are:

HP DL380G5

ComponentFirmwareDriver

Bios P56-01/24/2008-

ILO1.431.13.0.0

Networkcards2.1.2.04.4.21.0

Raidcontroller1.786.12.4.32

Videocard-6.14.10.6744

GilaMonster (7/21/2008)

---

The best part was that a few months...

just a ping back http://www.sqlservercentral.com/Forums/Topic510666-1291-1.aspx

Oh indeed, sqlserver will try to make its work as easy as possible by grabbing all the ram it actualy needs.

Probably it decided to grab some more because of the...

Thank you for providing the extra parameters Jeffrey.

Apparently those weren't in BOL sep. 2007