You have a lot of the cache allocated to ad hoc statements?

Have you identified these and suggested making them stored proc's at least?

I think the number will fluctuate as long...

You might need to see what is being allocated to the different plans. adhoc plans, procedures etc.

Baseline the results and see where they fluctuate. You can then see what is...

Hey,

What collation are you using?

If you want the query to be accent insensitive, you might have you use a collation hint on your comparison:

eg:

SELECT *

FROM Venue

WHERE

Name...

MERGE is good, but difficult to manage with key conflicts etc.

You may have to redesign your identity ranges on each table, or put a method together on how you are...

Another link you may want to consider looking through:

This shows you how to configure the backup job correctly, making use of the build in stored procedures that ship with BizTalk,...

David Rich (11/13/2015)

---

I have never managed Biztalk databases and heard from a Biztalk guy that the way these are handled is lot different from normal SQL DB backup and restore....

Have a look at this link:

https://msdn.microsoft.com/en-us/library/aa546765.aspx

tauseef.jan (11/13/2015)

---

I think I know what has happened.

Around 2 weeks back, we had an outage on this server. and it was decided that the storage on the E:\ drive needs...

I think the benefit would be to use the in-memory tables as a landing table, for ETL loads etc... left in schema mode only.

If you set the table to be...

Nope, unless you need the backups for something else i.e. rollback to a previous SQL version you may have migrated from, or to do the initialization again from the same...

What are the wait types for all the SPIDS?

What about SQL operators, SQL Alerts?

Are there any scheduled tasks on the Windows OS?

Windows Security... AD groups in different containers? Local Admin, power Users etc

SQL Trace flags that are enabled...

daniel.hughes 66721 (11/6/2015)

---

If you setup always on with a listener you will have a small amount of downtime (milliseconds) when the secondary becomes primary. Most of the time it's not...

Hey,

How often are you collecting the stats?

put this in your config file

QUIET="True"