I have one doubts.

Temdb Database side space was shirked by using shrinks command but HDD disk space not released

generally it will be free up space from HDD Once complete the...

Frequently facing space issues on tempdb. it is using more than 162GB always.

I have checked at tempdb properties it showing initial size is 750 MB for data file and 2...

Thank you for mention missed points(number), I have updated my documents.

What witness type do you intend to use for your Windows Server failover Cluster?

It means FULL RECOVERY MODE. For data...

Perry Whittle (11/17/2014)

Do you know how to deploy...

Thank you Mr. Perry.

Could you Pl. provide links or any document for how to configure listener in always on group?

Thanks for reply..

Database mirroring configuration involved in two different IP address for two servers.

Is it possible for one common virtual IP in always on group?

Thank you Gianluca Sartori, Delete script working fine...

Wow, Thank your script working fine and I moved since last 5 years data into archive database.

But I can't delete the records at source table as below command.

DELETE FROM...

As above output NUMA values is 2. Does it means NUMA is configured in server H/W side? So there are 2 memory slat attached in that server.

From MS site

1.For...

Thanks for reply..

I want to know this values (47%), is it Acceptable value? or can we decrease that value?

Thanks for reply..

exec sysmail_help_queue_sp @queue_type = 'Mail' ;

state: INACTIVE..

But I have recevied backup email alert and other alerts also...

As per your script email HTML Report not received for last 24 Hrs auto growth details. But executed successfully

Does it means if database autogrowth disabled at database setting?

That backup job run at under owner of 'servername\Administrator'

For the permission issues, where should i check at server side?

SQL Engine and Agent service running under Network service account.

Does Backup folder need to check? but this folder NT...

1. What's normal for this server for those counters?

I am not sure those counter normal values, It might be < 500 seconds for better (soft/hard page read...