How do you get that much information using Spotlight - i only seem to get a little bit of information.

Spotlight Enterprise has raised an alarm:

Connection: servername

Time: 03/03/09 16:12:45.964

Severity: High

Disk Queue...

Is the value updated now and not zero. Interesting thread.

You could update the database and set to auto update statistics sync set.

Database id is not 2 it is the main db table.

syscolpars, syshobtcolumns, sysprivs etc.

Mode X

Thanks

I wonder if you could add an alert for 100 cpu and then fire this off to get the SQL code

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

req.cpu_time,

req.total_elapsed_time

FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

in a...

Thanks - we just created brand new report server database on NEW SQL Server.

Just trying to configure the client where the IIS is and point it to this.

Seems like just...

Right click on the job view history your see duration

Have a look at the trace files.

insert.

--Trace Files

SELECT * FROM SYS.TRACES

When this retruns put in here ..

--Use this to get the details of the black box

SELECT * FROM fn_trace_gettable('C:\Program Files\Microsoft...

Sorry Mode X Lock Type is KEY, STATUS GRANT

SQL 2005

Do you have the MIN and MAX set with the memory on SQL and not leave as the defaults.

Plus there is a option to set the lock in pages in...

Man...they allow you to take vacation........u are lucky 😀

Some of you guys got your work out ha..........Is the Only DBA too....10 servers. Most of time everything is automated with alerts and emails daily. Runs itself...

No Outlook just go to databasemail inside SQL 2005...and follow the details...enter email server thats all. So much better that SQL 2000.

Must set the configuration on SQL...

Thanks guys for sharing i be looking at them today.

Yesterday i would have got notice there was a block on table but some person deleted the mail setting from DNS...

Today it is happening and it appears bi impromptu report blocked the record and the replication inserts etc had to wait.

Usually they set an isolation mode in their connections.

Is...

RCSI .

Today i am experience a problem that BI Group reading the data select statements and Replication is being held up with a hugh lag cause their apps are hanging...