prash.k.r.p (10/23/2012)

---

HI ,

Vas reaches up to 90 %, i mean when we check total memory is 108 mb and the free space would be below 20 mb like that. it...

prash.k.r.p (10/22/2012)

---

HI Jonathan,

I have one issue here, If nay idea please let me know

Some of my SQL server are not releasing a VAS memory so we need to restart the...

SQLUserC (10/2/2012)

---

Thanks for all the great replies. I had heard of this mapping of Profiler events to extended events, Jonathan, so it's nice to have a link to it. 🙂

I...

Yes, this is one of the fundamental architectural differences between...

Jayanth_Kurup (10/2/2012)

---

Keep in mind that you could end up getting much more information than you actually need so its usually better to stick with a Server side trace or DMV...

I recently recorded a five hour Introduction to Extended Events course on Pluralsight that answers every question that you ask here:

SQL Server:Introduction to Extended Events

If you need data to be...

Can you provide more details about your environment and how it is using SQL Server? For example, are there any Linked Servers in use and if so, to what,...

For those that don't have debugger skills and want to look at the internals of this, I wrote a blog post that shows how to dig into the internals using...

Hey John,

No worries, I just haven't had the time to go look at the code with teaching at Redmond this week.

hello mahesh (9/17/2012)

---

Jonathan Kehayias (9/17/2012)

---

hello mahesh (9/17/2012)

---

Still noluck. I tried searching for key words: 'dead' , 'victim' in xml and not found any.

May be it got overlapped as the deadlock...

hello mahesh (9/17/2012)

---

Still noluck. I tried searching for key words: 'dead' , 'victim' in xml and not found any.

May be it got overlapped as the deadlock event occured couple of...

Sergiy (8/28/2012)

---

Evil Kraig F (8/28/2012)

---

Quite correct, this...

The ability to do rolling upgrades of the Windows OS and SQL Server is a big reason. VMware HA doesn't provide the same capabilities as a failover cluster does...

tmagney (7/17/2012)

---

So how about if our cluster nodes are virtual machines and there are no power cords to yank on? Can I just go into vSphere and power down a...

CHECKDB would be faster than trying to check the metadata manually, that is why it exists in the product. If you have corrupt metadata in 2000, typically that means...