So, on a Prod server, when DB Team receives Hgh CPU Alert or incident for a sustained period. what would be the response?

do you check currently running sql stmts driving...

Try taking a look at theses 2 management views.  Change the ORDER BY in your queries to get highest use per I/O, CPU, Memry sys.dm_exec_query_stats

In general, I am checking 2 or more databases are placed in the same drive then would it cause any issue.

How can I leverage the sys.dm_io_virtual_file_stats to determine is there...

I do... but PerfMon is a picky thing... what works on one box frequently doesn't work...

1 way of fetching high cpu queries

-- top 10 queries by worker time

SELECT TOP 10

[qs].[last_worker_time],

[qs].[max_worker_time],

[qs].[total_worker_time],

[qs].[execution_count],

stmt_start = [qs].[statement_start_offset],

stmt_end = [qs].[statement_end_offset],

[qt].[dbid],

[qt].[objectid],

SUBSTRING([qt].[text], [qs].[statement_start_offset] / 2,

(CASE WHEN [qs].[statement_end_offset] = -1

THEN LEN(CONVERT(NVARCHAR(MAX), [qt].[text])) * 2

ELSE...

Thanks Jeff for those pointers. I am basically checking for an extended event trace definition file to track these numbers.

I never used sp_blitz and not sure how it will behave...

Checking on what columns should be of interest if we create some sort of trace.

Thanks Jeff.

How can sp_whoisactive help?

Anyone has any perfmon.msc file to measure how busy is my sql server?

Hi David,

You mean to say, I/O and CPU goes hand in hand?

How to identify if it is M.A.R.S and disable it?

Got it. Thank you.

I want to consider "Backup Size GB" and "DeltaNormal" columns and calculate percentage.

I know the formula (difference/old_or_prev_val)*100.0 but I am stuck I am stuck how to compare the previous row...

Hi Jeffrey,

Thanks for the explaination.

Is there a DMV or a way to confirm that redo is happening ?

-Bob