looks like modify_date in sys.objects updates rebuild date&time. but no further details available in system view on what caused that modifiation.

In short: answer to your question is no.

create database...

Vashi,

Need more inputs to understand the issue better (Hardware, SQL Configurations, DB Size, OLTP load, ETL etc)

Is this value exceeds consistantly or only specific time?

Most probably this is side effect...

I do not remember exact fix for this issue. focus on driver updates, try with ADO and OLEDB with different properties. thanks.

seem my response is not updated here.

we fixed that issue by updating DB2 client driver, changing DB2 data source property b/w ADO and OLEDB

and by trying differnt DB2 property values...

hi,

Pls have a look at Glen Berry's dmv collection (available in below link).

http://www.sqlservercentral.com/blogs/glennberry/2011/10/18/october-2011-sql-server-2008-diagnostic-information-queries/

both sys.dm_io_virtual_file_stats and sys.dm_db_index* dmv's helps to isolate db and object specific pains.

My few cents here.

1. run wait stats query available in below link and share top 10 records.

http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

2. isolate the db having the pain. sys.dm_io_virtual_file_stats dmv will help...

Abi,

To find the root cause Microsof team had installed an utility that captured memory dump. MS team analysed the memory dump and found the root cause.

I am giving complete details...

Perry Whittle,

My blog name is LivingForSQLServer. Its not just a name sake. I mean it. 🙂

and I had this doubt while writing articles on Storage internals concept.I believe (as one...

Thanks GilaMonster. Issue is resolved.

I have an update on this as this could help others.

Its a .net framework issue. new patches provided by Microsoft fixed this problem.

Nice to see comments from James and SanDroid.

I would like to share my comment on James reply.

"Jack-of-all trades a good DBA does not make. I do agree with knowledge of...

Nice to see your comments James Stover.

To me, I have improved a lot in last 1 year both financially and technically.

Technical front : I have started writting article in SSC, started giving training to my Organization...

here is my thoughts:

1.Performance front:

We can expect 256 GB RAM and 100 TB better version of SSD, 4 times faster processors and may be consistant 100 MBPS wireless Broad band...

Thanks Ken