good to hear it worked out 😀

Does the cause in the KB applies to you?

http://support.microsoft.com/kb/925976

http://www.sqlservercentral.com/Forums/Topic664852-146-1.aspx

Can you post the contents of the summary.txt file located in

%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG

am i missing something?

isnt performance dashboard SQL 2005? and replace with data collection in 2008?

what is the result if you run

select @@version

on the server?

what i mean to say is that there is a possibility that by a restart SQL server is rolling back transactions which were not...

rollbacks of transactions.

check youre SQL server log if no info is there try tracing

if youre using databasemail you can just disable it

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

that would be you re first action if you want something inplace concerning disaster...

setup PLE en buffer hit ratio alerts, those will be of more use then you re mem usage

See here the the code for creating the alerts

DECLARE @sCounterObject varchar(32)

DECLARE @PCstringvarchar(256)

IF @@servicename...

ravisamigo (3/24/2011)

---

Dear All,

Please advise how to set the alerts on the below conditions.

1. If SQL Services stopped.

2. If Database goes offline\suspect mode.

3. If RAM utilization increases more than 85%.

4. If...

THE-FHA (2/24/2011)

---

Hi, I have similar problem, i have Disk1 for inst1, disk2 for inst2, and disk3 for inst3 but i cant have other instances running on the same SQL networkname.

pls...

SKYBVI (2/24/2011)

---

TheSQLGuru (2/24/2011)

---

SKYBVI (2/24/2011)

---

I also dont like shrinking the tempdb personally.

10gb is fine for a 340 gb prod db, i know that.

But my manager doesn't like that.

I told her many...

These are intresting discussing between OS ppl and SQL DBA'ers. If you can the discussion ends with not have the ntfs rights you can always ask for a share of...

i dont say it dont work, i say MS dont support it