MyDoggieJessie (4/11/2011)

---

This is basically The situation I have in my Data Flow:

Flat File

|

Derived Column

|

Data Conversion

|

SQL Server Destination

Are you saying something like:

Flat...

harun-974445 (4/12/2011)

---

Hi,Thank you for your interest

I want to optimize my performance using below actions on my SSIS package

1.Reading same source once and transfer same Data several destinations using buffer or...

Did you check the execution plan to make sure that the index is being used?

Is there a performance difference when running this statement through SSMS and/or the client application?

Is there...

Thanks for your reply...

Yes I can just go for a 'simple' upgrade and do any neccessary cleanup afterwards! In this way I won't...

Great Thanks! I'll have a look...

Regards

Brian

TheSQLGuru (12/29/2010)

---

brian118 (12/29/2010)

---

PaulB-TheOneAndOnly (12/28/2010)

---

I'll take #2

Assuming SAN/Network are working properly chances are you are facing some hot spots. A single file Tempdb sounds like a possible cause but I'll suggest...

PaulB-TheOneAndOnly (12/28/2010)

---

I'll take #2

Assuming SAN/Network are working properly chances are you are facing some hot spots. A single file Tempdb sounds like a possible cause but I'll suggest to further...

Jeffrey Williams-493691 (12/28/2010)

---

A couple of things:

1) Are you sure you are running SQL Server 2008 Enterprise Edition and not Standard Edition? Use one of the following to verify:

Select @@version;

Select...

Not exactly since this time I'm directly at the client site, equipped with a much better hardware, however...

Not really! One of our client requested this feature to...

Nadrek (12/17/2010)

---

brian118 (12/17/2010)

---

Thanks for your feedback!

I have 8 core allocated to the SQL Instance, and although I specify MAXDOP=4 for the index rebuild operation, I'm seeing only ONE core spiking...

Nadrek (12/16/2010)

---

Watch CPU core performance during the rebuild; on a 16 core physical box, using 2008 R2 Enterprise (i.e. parallel rebuild), and up to 500MB/s of sequential disk transfer rate...

With poor performance i understand slow Selects or...

Oliiii (11/22/2010)

---

If the index you are rebuilding is a partitioned index you could only rebuild the index of a specific partition (See ALTER INDEX in BOL).

If you use 2 tables...

Nakul Vachhrajani (11/19/2010)

---

Can you confirm if the SQL Server is configured to use all processors (CPU affinity)?

Also, depending upon the query and the load, SQL Server can choose not to...