Thanks for reply

I do have a question though.

Server OS’s are x64, and even though I have set the value for LPIM with the service account, I have never seen a...

TotalServerMemoryMB - 3270.125000

For the Lock page memory enable

---------------------------------

Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out...

Thanks for your valuable reply. I hope, i am going to correct path for fixing memory related issues.

As per memory overivew result in production server as below

PhysicalMemoryGB - 8.00

BufferPoolCommittedMemoryGB...

Thank you for replay

Yes, I have enabled Lock page Memory in Local policy setting.

Now Performance Tap showing 4.55 GB after SQL services restarted on yesterday..

Sqlservr.exe using 103 MB for current...

Thanks for your replay...

Mr. Jeff comments is good method stoping IIS services instead of using single user mode in database side.

I have done migration activity last weekend and application aslo...

Mr. Perry Whittle, one final question

1. What is the best pratices & procedure restarted both server principal & Mirror? if restart required.

Pl.confirm

Do we can normal restart method followed or any...

Thank you for cleared all my doubts..

Is there Free Tools for monitoring Database Mirroring session? not in SSMS Launch Mirror Monitor

Thanks for reply..

In second question, Mirror database not read to use an application level during the mirroring session, when principal database goes down? how can up mirror database for application...

Thank you again for more details given me about mirroring

I want ask some question about database mirroring part.

1. Mirroring configured both principal and mirror server by same domain account1, now...

ok, thanks for reply

By default running every 1 mintes mirror monitoring job for both principal and mirror server database, so if change these job run time every 30 minits jobs...

Thanks for Reply...

one more question about change of domain account for SQL serve account?

Currently domain\userA - By configured database mirroring for both server principal & mirror server.

pl. suggestion me,

Expected to...

server is non domain & sql service account running local user account should need to create database encryption certificate, and create login, grant connect to mirror end point etc..

If server...

ok, server is not windows domain group? it is workgroup

As blow result, it showing too much single use plan in TeleData Database, Should I change database setting FORCED parameterization for reduce the single use plan?

sum_SizeInBytes_MBCnt_plansDB

1452.474777 ...

For adding new data files (ndf or mdf) in primary filegroup, application might be gets slow performance due to round robin seraching data from different datafiles. Are you any specific...