Rob has the winning post - there are many things other than the buffer pool that eat memory.

I agree with Colin that 44GB is too much to give the buffer...

I don't know what the OPs problem truly is. But I will say that anything that needs a scale of 30M had better be designed and programmed and maintained...

I am betting this is a database that has been in FULL recovery mode forever and has never had a transaction log backup. This is a VERY common problem...

1) Do you have any idea what file or files is taking up the space you had yesterday?

2) select * from master.sys.databases and look for files that are in FULL...

1) Don't you hate it when the OP doesn't put in the full set of requirements to start with??

2) This sure does sound like a homework assignment to me....

Andy I think I would have been on the phone to Microsoft product support well before I hit 3 days trying to resolve this issue. This seems to be...

Well, I for one agree with the OP - I have wanted the ability to do completely unlogged operations for a long time now. There are times or situations...

I would simply set a few filters to restrict what is logged. Like > 0 sec duration (or even higher like >10ms). Maybe limit it to the databaseid...

>> Do you get parallelism with Jeff's solution? I would think that would help a lot.

>> T-SQL UDFs always generate a serial plan.

Is that for SELECTs or just for modification...

1) the OP's question is moot without a critical piece of information: what is the IO demand of each database. Also you need to know the IO parameters...

GilaMonster (5/7/2009)

---

Dunno if you noticed, but I asked the question almost a year and a half ago.

What I ended up doing was querying the tran log before each backup, looking...

Gail, I think there was a thread on this topic on the MVP forums before you got your award. Try a search there. It may have been last...

Be VERY careful assuming that you can consolidate a bunch of servers just because CPU usage on each is very low. What is the IO demand?? That will...

Flo, are you getting your reads from SET STATISTICS IO ON? IIRC UDFs don't report IO correctly in this manner. Try getting them with Profiler.

Ashish Pathak (5/1/2009)

---

I have gone through the entore thread. Could you please tell me how my solution is so suboptimal. Will it not work in any condition or will it...