Use the new feature for 2005 its called database mail .

Click the sql agent and ensure to select the option to enable this.

Thats it..set up your email server and do...

Thank you for the clarification.

Thanks Gila...

Interesting...so setting the MAX has allowed the data to be stored in buffer cache which is fetched from physical disk to reside in memory (buffer cache) so the next time...

Tracey, it looks like this server has 16GB of memory on it. Can you confirm?

Yes this is correct 16 GIG.

Two instances of SQL - set both min to 1024 an...

Gila.

Probably IO contention.

What do the perfmon counters Physical Disk: Avg sec/read, Avg sec/write and % idle time look like for the drives with database files?

Is this total or...

Thanks for thread...expecting Available MBytes to be increased..during day get down to 98 MBytes.

So fixing min/max and lock in should give SQL more memory to prevent it paging o/s.

If 64 bit you do not need to do /3gb switch in boot up and only on 32 bit is this correct.

Only on sql standard editions and not enterprise?

Did the one guy mention raid 5...this is just for read and raid 1 for writing to?

Can someone explain the LUNS part..is there usually x number of drives at say...

If you are seeing processes block themselves, you need to review what type of waits you are encountering. My guess would be that they are CXPACKET waits - which means...

Is there a way to see the top blocking to kill...i had probrably 100 blocks on the database yesterday and it became very hard to see which one to kill...

No shouldn't be because of lack of backups...1 hours is good..or could do 15 minutes if they are very big logs to keep them down a bit when backing them...

Is it share point by any chance and they are rebuilding indexes this could take for ages.....

Thanks that a good idea. Is there a way to clean them out without a restart of SQL Server.

I don't think you can do master from sql 2000 to sql 2005..only version to version and same service pack.

If you need all the logins look up sp_help_revlogin and run...