Hi

Thank you all for the response.

No, this is not clustered. It is a standalone and I know that SSRS cannot be made Cluster aware.

I've anyhow successfully completed the installation...

Hi Gail,

Thank you for the response,

Actually, that was an RDP session and I unfortunately could not get all of that pane into the snip capture.

I have deliberately unchecked the...

Just to add I've also noticed quite a few logwrite waits, hence added the avg sec/write counter as well. The graph in question is for this counter.

Hi,

did not want to leave this topic incomplete as this might be useful to someone else.

We logged a ticket with Microsoft Premier Support for this and the answer to my...

Thank you Gail.

Will be checking out the URL.

thanks,

Hi,

Sorry about the earlier post.

I just realized that about 10 stored procedures depend on this function. This function does not return anything to the client. it does so only to...

Thanks for the wonderful Analogy Gail.

No wonder the wait time inspite of being converted into seconds(divide by 1000) from milliseconds show such a long time.

I understand now that many...

I don't think the disks should be a part of the cluster in the first place.

Always ON HADR solution does not use Shared storage like the traditional SQL failover clustering....

I am not sure if you have tools to do all instances at once, but you might want to check out the SQL server silent install script.

don't quite remember it...

Also, you have to ensure that this type of colum should exist in the table being replicated.

It should be a unique one and also have the ROWGUID property.

I would...

Use dbcc sqlperf(logspace) to check the free space available in the log file and shrink accordingly.

You cannot take a log backup on a database which is in simple recovery.

We are also in the midst of implementing a merge replication solution in our company and we encountered the same issue.

There should be a column in the table with some...

Thanks you folks.

I did this through T-SQL alter table statement and users were unaffected with the operation.

thanks,

Hi Steve,

ITs not slow or anything, Infact the database is in its nascency stage still.

Its just that they've asked me to setup maintenance plans for this database and they specifically...

Thanks Steve.

However, This is sort of getting on my nerves and the app owner specifically asked me NOT to rebuild FT catalog.

Is there any reason that I should not...