I am seeing the same message in the errorlog.

SQL Server 2012 (11.0.3373). We are using AlwaysOn AG's and have configured and are using the AG Listener for read only...

Jeff Moden (8/27/2013)

---

I'm not so sure that's true. If the computer is re-booted, the start of a new sequence might not be >...

Erland and Kevin...this is great information.

I will definitely look into the fill factor.

Sequential GUIDs definitely would make sense.

I am in the process of pushing Session off of SQL Server so...

TheSQLGuru (8/22/2013)

---

1) Sorry, but I cannot ignore having session state stored in SQL Server. :w00t:

2) You have a varchar(100) as your clustered index. Does it look like a...

Perry Whittle (3/21/2012)

---

Calvo's link is fairly detailed, you may also see my article at this link[/url], review the top section for installing the Windows roles and services which include Windows...

I didn't get much on this but here is what I have decided to do...

I have modified the sliding window filters so that the sliding window will always start at...

I know this is an old topic but I ran into the same situation and was able to determine that my filters were causing me problems.

I figured I would post...

Any resolution on this?

I am interested in what you found was the cause of increased compiles and increased number of cached plans.

If you are having parameterization problems with a single...

Before anyone replies to this...I have answered my own question.

I entered my whole post and the answer hit me upside the head as I was typing the last sentence.

For education...

Final followup to this thread in case anyone was interested....

We ended up having the problem re-occur and neither Microsoft nor I could determine the source of the issue even with...

Do you have a personal vendetta against the FOR XML clause? You haven't provided the business need for the sproc. You haven't supplied the definition of the sproc. You haven't...

I did...

Yes, am am now capturing and trending these numbers daily.

2)...

NameMinMaxConfigValRunVal

Ad Hoc Distributed Queries0100

affinity I/O mask-2147483648214748364700

affinity mask-2147483648214748364700

affinity64 I/O mask-2147483648214748364700

affinity64 mask-2147483648214748364700

Agent XPs0111

allow updates0100

awe enabled0100

blocked process threshold08640055

c2 audit mode0100

clr enabled0100

common criteria compliance enabled0100

cost threshold for parallelism03276755

cross db ownership chaining0100

cursor threshold-12147483647-1-1

Database Mail XPs0111

default...

michal_marek (10/12/2010)

---

First question:

Are You set "lock pages in memory" in gpedit.msc for account sqlservices?

Twice:

what are you set RAID for Database, TempDb, Log Files... ? It is...