Thanks. Ya stats are up to date and we are just revisiting the Disk Configuration in Hyper V platform today to address this issue. Will keep you inform about the...

Hi Jo,

Thank you so much for your reply. Yes, the VM Host machine also upgraded to Windows 2012 STD 64 bit edition....

Hi Thanks for your feedback. On this i am having similar issue and i am trying change the CmdExec Worker thread value , but after restarting the SQL Agent the...

Hi Thanks for the reply.

1. What operating system do the current and new machines use?

Windows 2003 Server.

2. Yes any new node needs to have the SQL server software...

Hi Craig Thanks for the inputs Yes , we have SAN and each V Disks is created to assign in each Server. I am in the process of getteing the...

Dear David/Craig,

Thanks for your inputs. Yes we are having huge Data in the Drives and observed that load on Physical is is high. after that i have moved some physical...

Hi All,

One more update in this process.To confirm the above query i have configured Log Shipping Process in testing server.after successfull run of process we Shrink the Database which has...

ok i agree rebilding the indexes will increase the log file..

Actually i want to show management after cleaning up the database this size got reduced from Ex: 200 GB...

hi,

Thanks for your quick update update.. Actually i am rebuilding the indexes every during the non-working hours.. ok after Shrink the Database i need to rebuild the indexes. the performance...

Thanks alot for your inputs.. by using that login i can able to achive to deploy the report in reporting server.

i am trying to create a new log for instance..here...

hi ,

thanks for your valuable suggestions:

Before initiating the log shipping from primary to secondary server i have created the login in Primary server and i mapped associated databases in User...

hi Thanks for your quick reply..

Actually in my production environment there will be always approx..170 Users connected to the database.

out of those 170 i can able to see more than...

hi,

i don't have any AWE enabled in the present senario.beacuse its a 64-bit OS. and i have set max memroty as 10 GB in the sql server properties.

hi Ajit,

by suing the same query i have identified that long running queries in the database.now i am in a process to tune those queries.and some times i am gettting...

hi Markus,

There are few queries which is taking time to execute..but in the application level they have set that connection timeout period as 100 sec. for testing purpose i am...