Shameless bump.

An alert and a job:

Alert:

EXEC msdb.dbo.sp_add_alert @name=N'CPU Alert',

@message_id=0,

@severity=0,

@enabled=0,

@delay_between_responses=0,

@include_event_description_in=0,

@category_name=N'[Uncategorized]',

@wmi_namespace=N'\\.\root\cimv2',

@wmi_query=N'SELECT * FROM __InstanceModificationEvent WITHIN 180 WHERE TargetInstance ISA "Win32_PerfFormattedData_PerfOS_Processor" AND TargetInstance.PercentProcessorTime > 25',

@job_id=N'892ab371-3ce3-42a7-9f8d-b846496db723'

Job:

USE...

Sorry, I didn't look hard enough!

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-453&locale=en-us

Thanks. Does yours run all day?

Actually that's a fair point. Many thanks. 🙂

As I said, is it possible to work out how much of that is via AWE? Thanks. 🙂

32 bit Windows 2003

I think you're right, maybe I was just trying to be too clever. Now to also consider how to copy the data back to a central repository.

Thanks, will have a look. I must admit I've not looked at Service Broker so I have no idea at the moment. :unsure:

They monitor performance so I need to get an at-the-time snapshot. I already use UNSAFE as they grab perfmon stats so I definitely take your point r. over relying on...

Could you not create the table in tempdb?

The only thing I can think of is have a small audit table which would contain the step name within the stored procedure.

So your stored proc might be something like:

Create...

You can use the sys.dm_os_memory_clerks DMV as follows to find out how much memory SQL Server has allocated through AWE mechanism.

select

sum(awe_allocated_kb) / 1024 as [AWE...

Or

use tempdb

backup log tempdb WITH NO_LOG

dbcc shrinkfile (templog,0)

dbcc shrinkfile (tempdev,0)

We've had a similar issue on one of our environments. The only explanation I can give at the moment is similar to problems when attempting to shrink the transaction log...