Clearly you cannot rely on some monitoring product telling you your memory is being inappropriately used since the threshold could be set to any number.

pages/sec is a simeple and effective...

With proper monitoring you should be able to KNOW if you are having memory pressure. Things like pages/sec, dbcc memstatus, various DMVs can inform you about this. ...

GilaMonster (10/12/2007)

---

In my experience it has the most impact when the aggregated columns are also in the index.

CREATE TABLE Payments (

PaymentKey INT IDENTITY PRIMARY KEY,

CustomerID int,

InvoiceID int,

PaymentDate datetime,

Amount Numeric(17,5)

)

Assume...

Yeah - thanks Paul. I actually had it in my head to add a note that truncate_only was going to be deprecated but got distracted by a darn work...

As you mention, SIMPLE recovery mode would eliminate the issue with tlog growth (unless you get a runnaway DML spid). A sql job that regularly (once per week?) runs...

Doing a full backup will NOT allow log file to shrink. You must in some way backup the log to allow space reuse. This is a VERY common...

All I can say is that it is REALLY scary that a company has an untrained/inexperienced DBA managing critical infrastructure!! I have been doing this for 15 years now...

I strongly advise clients to stay away from the Database Tuning Advisor. I know some have had some success with it, but I have seen it absolutely destroy database...

That is for used box. .NET stuff is freely downloadable/installable/distributable from download.microsoft.com. Best of luck with your endeavour!

<$200 is my guess for a machine to serve that data. 🙂 1 cpu or perhaps 2, 2GB RAM, 1 drive. Note that that doesn't get you...

I would decide first what your budget is. Then hit eBay or some other used-equipment seller and get what you can for your budget. A LOT depends on...

I would go with at LEAST 30GB for OS partition - perhaps 40. Seems like EVERYTHING these days puts crap in the os part - especially the installer directory....

I would recommend you look at the new Vostro 1700 model. I am LOVING mine - Core 2 Duo CPU, 2 hard drives, 4GB RAM and an awesome monitor!

Couldn't find it in the postings, but I bet you have only 2 cpus - maybe 4? parallelization takes a good bit of effort. You have to split...

Clearly you need to find better consultants!! 😛 Did you accept the code from him/her with such poor performance, or did it slow down over time with data...