Then it is for sure to do with your IO sub system.

For larger DBs and Slow DISKs this might be expected. Because I personally had an experince of shrinking...

What is the WAIT_TYPE for that process?

use sys.dm_exec_requests DMV for that session and look at the wait_type column

Regards,

Nawaz.

Thank you David,

You are pointing me to the same article that I did in my previous posts.

What has prompted the question, are you...

Hi David,

Thanks for the reply. I am aware of the fact that any DDL changes to the underlaying tables, or modifications to the SP itself causes the SP plan to...

Hello,

Can anybody help me with this?

Regards,

Nawaz.

Hello,

By default SQL Server is designed to use memory in large quantities, in order to cache data pages, plans and other DB objects in the Memory (Buffer pool).Under noramal conditions...

CREATE INDEX IX_1

ON 123 (A)

INCLUDE (B,C,D,E,F,G,H)

Having one Index as quoted above will make much sense.

Hi All,

The issue has been solved. I am extremely sorry for all the confusion I caused. There was a bug in my script that caused it go in a infinite...

I have run below 2 queries for looking at the memeory details.

SELECT

((SI.physical_memory_in_bytes/1024.0)/1024.0)/1024.0 AS PhysicalMemoryInstalled

FROM

sys.dm_os_sys_info...

Can you provid us the details on if the service pack resolved your issue.

Regards,

Nawaz.

SQLSACT (7/17/2013)

---

dedicatedtosql (7/17/2013)

---

Thank you very much for the reply. So all the memory that SQL Server process is taking up is called the Buffer Pool. In other words when we...

Thank you all for answering my questions.

TheSQLGuru (7/17/2013)

---

dedicatedtosql (7/17/2013)

---

Thank you very much for the reply. So all the memory that SQL Server process is taking up is called the Buffer...

Thank you very much for the reply. So all the memory that SQL Server process is taking up is called the Buffer Pool. In other words when we configure Max...

Hello Tim,

Outstanding Book. Actually your book has shaped me into being better DBA. The more I read the better I am becoming at trouble shooting the DBs in my environment.

I...

Excellent article. The best part was the demo. I think in 2012 the actual execution plan it self shows tempDB spills with a warning sign on the SELECT operator.

I...