good one Steve 🙂

I could see some answers in below links...have a try

http://www.sqlteam.com/article/notes-from-an-upgrade-to-sql-server-2005

http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/25924/Complex-queries-run-slow-after-SP4-installed

http://www.sqlservercentral.com/Forums/Topic1027752-146-1.aspx

http://www.mssqltips.com/tip.asp?tip=1230

suggest you to

1. rebuild indexes, update statistics of all user tables

2. run...

Kevin,

as Server is running in 32 GB RAM, I forgot the possibility of keeping/reading all pages from memory irrespective of hard disk and fusion-io.

As you suggested, I 've done a...

Great answer Kevin.

got few inputs to investigate further.

I have asked server management team to provide specification details of both disk and fusion-io and asked them to perform stress test on...

Thanks for your reply.

in Brent's Fusion-io review post,

(http://www.brentozar.com/archive/2010/03/fusion-io-iodrive-review-fusionio/)

He has mentioned some hardware level details to get maximum performance out of Fusion-io

like,

1. In order to get your money’s...

Roi,

Forgot to mention one point.

guess you know the fact that, most of the DMV statistics are cumulative, meaning you cant filter last 1 or 2 hr performance statistics from most...

Thanks Koen for the quick response.

We get the same error ever after changing querytimeout of DB2 client to 0.

is there any property to be configured in DB2 Server? any...

Some extensive set of DMV's are present in below url to cover statistics of every part of hardware and sql server db, object level.

http://www.sqlservercentral.com/blogs/glennberry/archive/2010/12/29/updated-sql-2005-and-2008-diagnostic-queries.aspx

first create reporting tables for...

Question is not having more details on issues to narrow down the issue.

if performance issue is with few queries:

1. check execution plan and address pain points

2. update statistics

3. check server...

SQL Iron Chef,

Here is simple excercise to test this scenario.

create a table name tEmployee,

create table tEmployee(

intEmpCode int,

strName varchar(100),

strCity varchar(100))

create NCI on intEmpCode,

CREATE NONCLUSTERED INDEX NCI_tEmployee_intEmpCode ON tEmployee(intEmpCode)

Insert 100 dummy records...

here is another try. this query combines both sys.dm_db_index_usage_stats (for index usage) and sys.system_internals_allocation_units (for collecting pages allocated)

select si.name IndexName, OBJECT_NAME(si.object_id) ObjectName, si.type_desc, internals.total_pages, ius.*

from sys.indexes si

inner join sys.dm_db_index_usage_stats ius...

I couldnt see any response for my query.

can any SSIS expert have any idea abt this error?

or can u pls tell me the right place to ask this query?

Thanks David BAFFALEUF and Gila Monster for your reply.

hey here is my comments

if your key tables are huge and query returns huge number of records

or too many non unique values in keys, u really cant control...

here is few points i got from sqlmag

sql 2005 arch. enhancements

1. statement level recomiples - (in sql 2000 its batch level recompile)

2. Parallal query option (PQO) enhancement

3. enhancement in memory...