Viewing 15 posts - 38,686 through 38,700 (of 49,571 total)
You might want to remove the call to shrink the database files as well. See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
June 4, 2009 at 3:27 pm
Probably bad execution plan due to out of date stats and probably because DBREINDEX updates stats.
Try UPDATE STATISTICS next time, see if it helps.
June 4, 2009 at 9:07 am
Lynn Pettis (6/4/2009)
Here we go again with truncating and shrinking logs, especially when people don't understand what it is they are doing.
Do you understand what he's done? Cause I'm not...
June 4, 2009 at 8:54 am
Sorry, I don't understand what you've done or what your problem is. Can you explain more please?
June 4, 2009 at 8:51 am
3rd party monitoring tool?
June 4, 2009 at 8:28 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic728780-360-1.aspx
June 4, 2009 at 7:36 am
TRACEY (6/4/2009)
345 milliseconds.So that is not < 12 ms so leading me to disk problem here.
Where did the less than 12 come from? With avg sec/read and...
June 4, 2009 at 7:30 am
mohit.sharma2 (6/4/2009)
The dll for resorucedb can be found underdrive:\Program Files\Microsoft SQL Server\MSSQL10\Binn\
Assuming default installation path.
That's not where you would find it on my machine, for example.
June 4, 2009 at 6:11 am
joeroshan (6/4/2009)
DBCC SQLPERF("dmvname",CLEAR)
That only works for 2 DMVs - sys.dm_os_latch_stats and sys.dm_os_wait_stats. No other DMV can be cleared using that.
eg
DBCC SQLPERF("dm_io_virtual_file_stats" , CLEAR)
Msg 2526, Level 16, State 12, Line 1
Incorrect...
June 4, 2009 at 6:04 am
Paul White (6/4/2009)
Interesting - knew all that except the no IAM scan in an update plan.
Think it was that. I know it was a discussion on 'ordering' in...
June 4, 2009 at 6:00 am
Other than for the sys.dm_os_wait_stats and sys.dm_os_latch_stats, there's no way.
Edit: added the other DMV that can be cleared
June 4, 2009 at 5:22 am
It's in Books Online. Title of the page is "Hardware and Software Requirements for Installing SQL Server 2008"
Help url (for books online, not web) is ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm
June 4, 2009 at 5:17 am
Paul White (6/4/2009)
June 4, 2009 at 5:15 am
June 4, 2009 at 2:31 am
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
June 4, 2009 at 2:30 am
Viewing 15 posts - 38,686 through 38,700 (of 49,571 total)