Is it possible there are any uncommitted distributed transactions? What is the initial file size for the log file? Is the recovery interval value for the database set at the...

markusstar (5/10/2013)

---

hi everyone

i am quite confused about read contingent security for cube cell data? I know that it is much stricter than read permission and that it applies to calculated...

TimC-690839 (5/13/2013)

---

I'm setting up my first pair of Sql 2012 servers using AlwaysOn. I set up backups to run on the primary and I understand that you can set up...

Is the storage offline when you are running the cluster validation tool? This is a prerequisite for the test.

allmhuran (4/18/2013)

---

I'm not 100% convinced. We only had one weekday with the hotfix installed, but this graph of timeouts captured on the application servers seems to indicate pretty clearly that...

allmhuran (4/16/2013)

---

Haha, likewise. The problem is a version incompatibility between sqlservr.exe and sqlaccess.dll. We've just been sent a link to an updated one, but we had already decided to...

Tommy Bollhofer (4/11/2013)

---

allmhuran (4/11/2013)

---

For mine, we received a private build, basically a direct copy over the sqlservr.exe and a few dll's. It took us to the following @@version. Tommy, I'd...

tsaolimkei (4/10/2013)

---

I would like to replicate transaction changes from sql server (2005 & 2012) to oracle 11g, I want the transaction changes (insert, update, delete) on tables to replicate to...

allmhuran (4/11/2013)

---

For mine, we received a private build, basically a direct copy over the sqlservr.exe and a few dll's. It took us to the following @@version. Tommy, I'd be curious...

TheSQLGuru (4/11/2013)

---

Thanks for the feedback on this. Did they post a public hotfix yet or is it still a private build? If the latter, please post the link...

FYI, just as a follow-up to thread I had going (NUMA and PLE on SQL Server 2012).

CU3 for SQL Server 2012 SP1 has been released which includes the following...

cheshirefox (9/25/2012)

---

We tried all sorts of fixes, including contacting Microsoft. Microsoft did not provide any feedback.

Finally - we executed the following in order...

DBCC FREEPROCCACHE

EXEC sp_recompile 'dbo.StoredProcedureName' (we preformed sp_recompile...

FYI, CU3 for SQL Server 2012 SP1 has been released which includes the following hot fix.

SQL Server 2012 experiences performance issues in NUMA environments

http://support.microsoft.com/kb/2819662

CU3 for SQL Server 2012 SP1 is...

allmhuran (3/14/2013)

---

Ah, well that's interesting. I am seeing performance degradation with the PLE drops as well as the movement of other related counters (eg disk % jumping to 100,000%... yes......

TheSQLGuru (3/14/2013)

---

One thing I don't see mentioned is if PERFORMANCE or actual IO or other metrics change when PLE falls off a cliff. If it doesn't, I would chalk...