Viewing 15 posts - 4,726 through 4,740 (of 5,843 total)
As an independent consultant (and knowing that you are newly so), let me paraphrase Robert Duvall in "Apocalypse Now": I love the smell of a train wreck in the...
May 19, 2009 at 9:20 am
GilaMonster (5/19/2009)
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.I almost hope it is.
I wish it wasn't...
May 19, 2009 at 7:53 am
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...
May 19, 2009 at 7:47 am
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...
May 19, 2009 at 7:45 am
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...
May 19, 2009 at 7:39 am
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...
May 18, 2009 at 8:16 am
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....
May 14, 2009 at 9:09 am
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...
May 14, 2009 at 9:07 am
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...
May 14, 2009 at 8:59 am
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...
May 14, 2009 at 8:56 am
>> 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...
May 12, 2009 at 12:34 pm
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...
May 12, 2009 at 7:31 am
GilaMonster (5/7/2009)
What I ended up doing was querying the tran log before each backup, looking...
May 7, 2009 at 9:50 am
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...
May 7, 2009 at 8:44 am
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...
May 7, 2009 at 8:41 am
Viewing 15 posts - 4,726 through 4,740 (of 5,843 total)