Check your 'min server memory' and 'max server memory' to see that they were not set to some arbitrary value. Also, if you are on 64 bit, verify the "lock...

You can also run a server side trace and filter on login, hostname, ip, Program_name. Run that for a week or so to give you a better idea.

You need to take up this problem with your email administrator. If you are using Exchange, you can send through a "smart host". That's what we do.

I would also suggest you monitor the counter : Page Life Expectency. This also gives you an indication of memory pressure.

SwayneBell (4/12/2011)

---

Craig Purnell (4/12/2011)

---

Hi, Need to clarify this a little more. The technique described above is done by an addon product called Snapmanager for SQL Server. It is not cheap....

SwayneBell (4/12/2011)

---

Wildcat (4/12/2011)

---

FYI - I believe the SAN company whose name starts with N does a restore on another LUN and then a checkdb on the database after it is...

I think that's right.

Jeff Moden (4/9/2011)

---

I think you'll actually have a difficult time keeping it down to only an hour. As the others have said, the only way to know is to...

Jack Corbett (4/9/2011)

---

For the abstract I think it is important to list 3 specific things you expect the attendees to learn from the presentation. For SQL Agent I'd do...

Yes,...

The SQL 2000 server, where you need to run instcat.sql against.

The Filter Daemon launches filter processes. Starting in SQL 2008, the Full Text engine is entirely within the SQL engine. See MSDN for more info:

http://msdn.microsoft.com/en-us/library/ms142541.aspx

When you say install Visual Studio, I am assuming you are referring to BIDS (B.I. Development Studio).

We typically do not install BIDS on production boxes, mainly because I don't...

doug 37293 (4/8/2011)

---

Good so far. Now I am receiving an error which is known per http://support.microsoft.com/kb/906954.

The fix is to run instcat.sql. Before I do this, I...

I have found that the MS Press books by Itzik Ben-Gan to be very good. There are several for SQL 2008. Plus, a lot of resources right here on SSC.