Thank you Grant & Johan.

Got it. Thank you for the help Jonathan and RatBak.

This is a big stored procedure which has multiple operations SELECTs, INSERTs within it and bunch of tempdb operations? The temp table error was something related to another operation within...

• This reply was modified 1 year, 7 months ago by  bobrooney.81.

This query is not getting blocked but sometimes going to runnable state and suspended state.

I tried to capture the actual plan but gave up after it ran for almost hours...

query is running over 2 hrs. What's runnable status mean? the cpu utilization in task mgr is around 30-40% only...

Reads are more. What can be done to...

Thank you Jeffery. Will test it on my sub-prod env.

Since backups on a secondary node must be copy_only backups - you have to make sure copy only is set.  Once you do that - Ola's utility will look...

Thank you Jonathan.

There are any number of things to check, but I generally focus on wait statistics and query times. And honestly, mostly query times. Wait statistics tell you what things...

Do you have 15-20 3TB databases on a test server and one of the databases is production?

How much storage do you have? It sounds like you have 30-60 TB...

I am looking for alert code when it is 70% I want to get an email alert automatically so that we can take the log backup or check to see...

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...