1) Did you show the xml query plan or all text plan and verify that the query was doing partition elimination and only reading the march partition?

2) Does the fragmentation...

A LOT of stuff happens when you issue a simple SELECT statement! While the select is running, you certainly wouldn't want someone to alter the table underneath you and...

Spot-on Mario!

Oh, and for this one "It's as if people naively think the tool itself will solve all their problems with no tuning necessary. I've witnessed this all too often...

blocking is definitely the first thing to look for here. 12 logical reads returning 200-300 rows is essentially instantaneous yet the query took 14 sec.

I told you how to check for blocks: sp_who2 active

you don't do hash joins - the optimizer can. forget I mentioned it

cross product is when joins are many-to-many...

1) have you checked for blocking? These two tables are EXTREMELY small and even if they are a massive cross product and/or have to do a hash join they...

1) IMNSHO, the tlog has nothing to do with the described behavior. It is a red herring.

2) You need to find out why, very specifically, things are running slow....

colin Leversuch-Roberts (5/14/2008)

---

Actually i was just thinking that each time a thread gets going on storage and SANs it really generates a lot of interest making me more than certain...

Marios Philippopoulos (5/14/2008)

---

dsc (5/14/2008)

It'll most end in answers like "It's not the SAN, it's it usage by applications". It's also almost impossible to get a meanigful overview of the current...

Any good perf tuner should ensure proper mentoring of permanent staff when called in for a...

stefanogalizia (5/13/2008)

---

HI all,

thanks for responses. The db is not serving a web site but a massive SMS sending, we are a mobileVAS provider.

At the moment, to be honest,...

Hans Lindgren (5/14/2008)

---

I just wanted to point out that if the DB is being hit 600 times per minute no SQL Server Instance would...

1) Several people here have a mis-conception about what a clustered index scan is. It IS a table scan in this case.

2) Jeff is probably right (as usual) -...

I believe the distance limit for LVD SCSI is 25 meters. (http://www.interfacebus.com/Design_Connector_SCSI.html). not sure of other, newer technologies, but 25meters gives a LOT of room for drives to attach...

CoetzeeW (5/13/2008)

---

WOW .....I query our 3.6 billion row table and all my reponses are sub second ..with out partitioning or splitting data in a federated concept neighter partitioned views ...

Good...