Thank you for the reply!

I use it and works like a champ. sql 2012 is actually improving on it with more options. It only governs when contention is happening on that scheduler, so keep...

prowlermax (11/28/2011)

---

Very informative. Thank you.

I do have a question. I am planning to upgrade a two-node cluster from SQL 2008 to SQL 2008 R2.

My plan was to tear upgrade...

When you check AWE in a 64bit instance, nothing happens. If you lock pages in memory, it makes use of the awe api. Set a max memory setting and you...

The internal pool is internal to sql server. It can use all the memory available. You should do a dbcc memorystatus and paste it here.

hxkresl (7/13/2010)

---

Reo (1/4/2010)

---

Hi All;

I was face a question - How to handle out of disk Tempdb on production server? ; In an IBM DBA interview.

The interviewer’s concern is that if...

Sounds like to me someone is not destroying their cursor 🙂

I see this every now and then..as http://support.microsoft.com/kb/307487 says, you must make sure no one is using tempdb...

MS made some major improvements for clustering in terms of setting it up. In my opinion, it is MUCH easier to setup and recover from a node that needs rebuilt...

What kind of traffic are you looking at? I let mine autogrow at 10% and I am getting millions of unique visitors everyday. The session job created by .net is...

Hi,

I actually run a 2 node A/A's with 1200 db's on each instance with dual quad core's and 32 gigs of ram for each node. Works out pretty good, but...

Thanks, problem solved 🙂

SELECT TOP 10

sql.text as sql

, qp.query_plan

, creation_time

, last_execution_time

...

The SP is cluster aware. Install on the active node. This is covered in the readme for sp3 for failover clusters.

There is no uninstall for SP3. You need to reinstall SQL 2005. Make backups of your system databases along with your user databases.