Thanks Lowell, It is working now..

management also not recommend to start the browser service. so in this case need to mention new port number in ODBC connection or web.config file...

Thank you Perry,

management plan itself working and deleted old days backup files after adding account in backup folder and given modify privileges.

I have tried manually run that script but not deleted old files

declare @DeleteDate nvarchar(50)

declare @DeleteDateTime datetime

set @DeleteDateTime = DateAdd(hh, -48, GetDate())

set @DeleteDate = (Select Replace(Convert(nvarchar, @DeleteDateTime, 111), '/', '-') +...

Thanks for posting wonderful script for schema change monitoring,

How will altered your whole script for monitoring stand alone instance only.. I don't want capture other instance thru dblink features...

Thanks

Pl. suggest me, Is there way to find out what are the transaction using more space in tempdb? any links.

I will discuss with application team to send report for tempdb...

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?