I was able to resolve this using anonymous subscription.

thanks for the help.

we dont take backups on secondary.

We were able to fix this.

this is what we did

1) We stopped Tlog backups on both primary and secondary

2) On the secondary we tried to remove the database from availability...

synchronous commit.

Thanks for the reply.

We already have the work around set up and its running fine. I wanted to see if there were any fixes that I might be unaware of....

edit sp_verify_subsystems in msdb. This inserts the value to subsystems table by multiplying an arbitrary number to the no.of processors. you can manipulate this number to get the desired worker...

Just curious , no business need. I was able to implement using CTE, but wanted to see if there was any ingenious solution to do it.

A case might be ...

i wanna wait for some time(seconds) to get a delta on resources and i want it as a function to sort based on columns

thanks for the reply.

Thank you. I will try that

Thanks for the info.

I will try this procedure to see if this will work for us

Sorry I was able to figure it out. Thanks. silly me:-D

exec xp_cmdshell '"C:\Program Files (x86)\Nmapmap" -p 1433 --script ms-sql-info --script-args mssql.instance-port=1433 localhost'

Thanks for the info.

I will play around in the test environment and will let you know.

Thanks for the response.

how or when do you specify the encryption key to be used if I start from scratch?

we are going to split the data across multiple drives and move it to a unshared datastore.

I will let you know if it made a difference or if i find...

we have more than 30 % free space on the drive. and for fragmentation: we are vmware shop with EMC SAN(VMAX thin pools) and EMC doesn't recommend running defrag from...