We are looking Far Disaster Recovery solution only, However our object is to have near zero data loss with lesser downtime. We have mix SQL Editions of Standard...

Thanks for the reply

Since we are looking for a DR solution, We can’t use Databases mirroring for Sql Standard edition. As Standard edition gives only synchronous mirroring and...

Hi,

Issue was resolved after applied SQL2012 Cumulative Hotfix 3

http://support.microsoft.com/kb/2812412?wa=wsignin1.0

Regards,

Vinod K

Thanks steve,

Is there any Best practices for SSAS configuration

Memory, max degree of parallelism etc..

Regards,

Vinod K

Thank you friends....

I have been assined 2 more ip to my server. But iam not able to bind the ips with SQL

Instances. Can any one send me the...

we are using VMFS Shared for the SQL Storage and hyperthreading was already disabled. would RDMs make any performance impact.

your right but as per Microsoft & VMware they are saying only 10 % performance hit will be there. In my case am getting almost 40- 50 % performance degradation.

Thank you very much my dear friends.

Will do the tuning as per your recommendation and update you incase of any issue .

Regards

Vinod K

Hi Gila,

The same queries are running fine on Physical Server. But it is not running on VMware. Hope you have checked performance counter output too.

The SQLServer Performance issue encounter after...

Thanks for your reply ...

But my quers were running fine on physical server it was not beyond 25 % on pick time. now it's showing 100 % on VM....

Hi guys

data file is increasing and i got the root cause. this is due Fill factor is set to 10%. So i just set to 90% and i have...

Hi

Please check your SQLSERVER service account.

Start service with domain account