I did reboot and all is well. It's the first time this has happened since I went to SQL 2k about a year ago. I'm wondering what caused it?? I'll...

Dan, Any adverse impact on performance? I set my max to 4.8 gig and for some reason the OS reserved memory got locked up and processing just died. Are there...

What if you want to use more than 4GB? I've got my switches set correctly, set AWE enabled to true, granted privileges to lock pages in memory and performance went...

Did you try rebuild the indexes on the table? I had something "similar" here and that did the trick.

Terry

We added the priveleges described above. It locked memory reserved for the OS and absolutely killed processing times (some jobs went from 5 minutes to 3+ hours). Am I missing...

These are jobs scheduled through the SQL Agent, each individual to a local drive. The tape sweep occurs once the jobs have completed.

Terry

All databases are under 500 MB. Currently I do them sequentially as well, about 5 minutes apart. I use Litespeed on our VLB reducing backups from about 3 hours to...

The account did not have the privilege but does now. Our network admin believes the server will require a reboot for this to take affect so once we can get...

We're running SQL 2K sp3, enterprise edition.

Terry

Sorry, should have also stated that we're running Spotlight and the way I can determine that we're only getting 2.8 GB is we get a buffer cache hit alert on...

BOL - Mail - SQL Mail. It gives you everything you'll need, both for creating the mail profile and for SQL.

Terry

Currently, we're only using Spotlight (maybe Foglight one day but due to costs, we started low). We're using it to monitor our SQL server machines to trap any issues that...

and DBCC INDEXDEFRAG

Terry

DBCC DBREINDEX

Terry

Steve is absolutely correct. We had an index inter-leaved with another index. We dropped and rebuilt both and everything has been fine since. Be sure to rebuild the offending indexes...