Yes Gila, I want to do the same. But, as per jessi experience it seems we might encounter checkdb constraints. So, I think even I need to experiment this. So,...

Jessie,

Thanks for your detailed explanation. I was referring to the...

Gilla thanks for quick explanation. We had microsoft vendor who came in past and recommended to use 8 data files of equal size as we have lot of tempdb contention...

Thanks Gila

I actually tried to query with

sys.dm_db_missing_index_group_stats

INNER JOIN sys.dm_db_missing_index_groups

INNER JOIN sys.dm_db_missing_index_details

but it is not much helping me.

Yes, exec query stats worked. I was able to calculate the CPU usage. Thanks.

Yeah Richard.. you are right. Also we do not have tools to monitor. will check with query stats

I just tried other way and resolved to get yestarday cpu utilization. But, can we also get sql scripts what went on yestarday which utilized high cpu?

--just added this step:

...

Thanks Sr.DBA for clarification. I Will try to follow up and see whether ports config can be done in my organization or not. Currently there are around 400+ servers. Need...

Sounds Good.

Thanks Gila. The object which has high buffer is required. It is from a very large DB (4TB). But by this I am seeing 96% of memory usage on my...

Try This..

create procedure dbo.sp_MSrepl_startup

as

exec sys.sp_MSrepl_startup_internal

Hello,

I received the following error when I ran the following command on Mirror server:

alter database dbname set partner

force_service_allow_Data_loss

Msg 1455, Level 16, State 106, Line 1

The database mirroring service cannot be...

Thanks Perry and All, I think I have learnt something new..Will implement on my VM machine and will get back to you if any more...

🙂