From what you have described that it looks like the problem could be at the web server application layer, do you have access to anyone who knows that well. ...

My Mistake I thought it was only in SQL 2008 R2, did it not used to be called "Change Data capture"? I had reviewed that once and for a...

OK to try and help you need to be a little clearer.

Is the process inserting the results of the select query into a table?

Is this all within the same database...

What you really need to do is setup some coding standards so basically a document that details what should happen when creating objects.

For example. If your system was predomenantly...

When you see this problem occuring have a look at sys.dm_os_waiting_tasks, you will see what requests are comming in and what the wait type is. This will help you identify...

As change tracking is only in SQL 2008 R2, if your on just SQL 2008 the products Lumigen and APEXSQL are worth looking at.

If you could post the code for creating the table and some sample data it would help.

I am pretty sure that indicates that the client app is not dropping the connetion once the request has completed.

You need to make sure that the client code opens a...

Try using sp_dbremove 'DatabaseName'

Its not possible to share the same DB on both clusters.

essentially each instance runs with its own resources, i.e SAN drives which are only accessible by one active...

How about creating a SQL Agent job with no default schedule, then run the job by calling your stored proc? the other option is using the xp_cmdshell system stored...

Thanks, it turned out to be easier than I thought.

First I would check how the server is running at a basic level checking the following counters in perfmon:

Hardware Resources

The counters required are:

•Memory: Pages/Sec

•Memory: Available Bytes

•Pyhsical Disk:%Disk Time

•Processor:%Processor Time

Network...

Not being cheeky but have you tried googling, "free helpdsk software"? There appear to be loads out there

Yes indexes can be replicated but not by default you need to set the options within the publication article properties.