Note that I said call OR patch. Also, I would not want to get black-listed by a...

Ninja's_RGR'us (6/15/2011)

---

TheSQLGuru (6/15/2011)

---

Ninja's_RGR'us (6/15/2011)

---

TheSQLGuru (6/15/2011)

---

1) use sp_whoisactive instead of sp_who2. freebie - learn to use it's goodness

2) sharepoint is HORRIBLE from a database perspective! there are quite a few...

Ninja's_RGR'us (6/15/2011)

---

TheSQLGuru (6/15/2011)

---

1) use sp_whoisactive instead of sp_who2. freebie - learn to use it's goodness

2) sharepoint is HORRIBLE from a database perspective! there are quite a few indexes that...

1) use sp_whoisactive instead of sp_who2. freebie - learn to use it's goodness

2) sharepoint is HORRIBLE from a database perspective! there are quite a few indexes that need to...

GilaMonster (6/13/2011)

---

No, if a clustered index scan is shown a clustered index (table) scan was used. Could it be that the second time the data was in cache and hence...

1) have you run a profiler trace, looking for recompiles while this thing is running?

2) have you run a profiler trace with STATEMENT completion on for each run to check...

no need to reinvent the wheel. use sp_whoisactive, an absolutely amazing freebie from Adam Machanic. See sqlblog.com for code (which is documented) and 30 different blog posts detailing...

You do NOT want to store large files in the database engine. Performance can be disastrously bad when those files get lifted up and force other more useful and...

There are SOOOOO many things that can make a sproc run slowly: parameter sniffing, widely disparate input parameters, data value distribution skew, blocking, IO stalls, any number of other 'waits',...

krishusavalia (6/7/2011)

---

Hi Everyone,

I am new into performance issue.I can post the Query or execution plan for my query which i need to improve performance.

I am using SQL server 2008. I...

This thread is over 2 years old. Please start a new one. Thanks.

Guess that should have been a "why" instead of a "how". :hehe:

I addition to reviewing the query plans you also need to check IOs done by each query and most importantly do wait stats and file IO stall analyses during the...

data value distribution skew can ABSOLUTELY cause the optimizer to estimate rowcounts that will lead to a plan that mathematically is most efficient based on the estimate but which due...

1) are you getting partition elimination in the query? my guess is not - either your query isn't written to allow this or you are getting screwed by the...