Hi Gila,

I agree with you but when i check sp_who2 in particular database users are in sleeping mode & CPUTIME is more than 20k. When i...

Hi Kishore,

No, it will not impact to Mirroring.

Thanks

Satish

Hi,

Please check the ports are open from Primary to Mirror & Mirror to Primary serves.

Use Telnet & find.

Thanks

Satish

Hi Shiva,

Can you clarify my doubt..

You mention in your comment 01 to 02 configure Mirroring & 02 to 03 configure Logshipping..... right

...

Hi,

Did you register your server with same name, if no mean please register & test it.

Thanks

Satish

Hi Muthyla,

Let me know one thing, you are creating Distributor DB 1st time in that server, if NO mean ok.

If...

Hi Sue,

First test it in Test environment because should be apply for Nodes only because In NODE1 & NODE2 store SQL Components & SAN store...

Hi Suo,

Ru upgrading the version or updating patch. When you updating patch on that time update 1st node then 2nd node but as per...

Hi,

When i run the profiler most of the time going to hang, I want to close this issue as soon as.

Thanks

Satish

Hi SueTon,

Please put SQL SERVER 2008R2 Enterprise edition DVD & give install after you will get MAINTENANCE option in their you will get option...

Hi,

Could you please share the error...

Thanks

Satish

Hi Gianluca,

I already assign 5GB to SQL SERVER before it was 4GB that time some users are going to sleeping mode after...

Hi John,

I created SQL Account because Windows they will not angry for part of System admin.

Attached screen shoot FYR...

Thanks &...

Hi,

Shall i create a just user account or Domain\user account because i created new account SATISH it's not working & even i tried services run on...

Hi,

I checked it is development server, i can't use profiler while they using server. If i use on same time Server will hang.

Satish