Forum Replies Created

Viewing 15 posts - 38,671 through 38,685 (of 49,552 total)

  • RE: Any idea what and why this is being generated? 'select top 1 1 test from sysobjects (nolock)'

    3rd party monitoring tool?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 8:28 am

    #1004675

  • RE: ALLOW_PAGE_LOCKS vs DEADLOCKS vs REBUILD INDEX

    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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 7:36 am

    #1004626

  • RE: Avg. Disk sec/Read

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 7:30 am

    #1004621

  • RE: Resource db in 2008

    mohit.sharma2 (6/4/2009)

    The dll for resorucedb can be found under

    drive:\Program Files\Microsoft SQL Server\MSSQL10\Binn\

    Assuming default installation path.

    That's not where you would find it on my machine, for example.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 6:11 am

    #1004562

  • RE: Clear DMV Stats

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 6:04 am

    #1004553

  • RE: Are the posted questions getting worse?

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 6:00 am

    #1004548

  • RE: Clear DMV Stats

    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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 5:22 am

    #1004527

  • RE: Hardware minimal and max requirements anywhere?

    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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 5:17 am

    #1004524

  • RE: Are the posted questions getting worse?

    Paul White (6/4/2009)

    BTW: I use INDEX(1) instead of (INDEX(0)) for the in-place update to ensure I get a linked-list ordered scan (to avoid a sort) rather than the IAM scan...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 5:15 am

    #1004522

  • RE: Difference between count and exists

    http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 2:31 am

    #1004469

  • RE: What should I do if one of my table is corrupted..?

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 2:30 am

    #1004468

  • RE: Can we put ldf file in different file group

    ldfs(log files) aren't in filegroups. Only data files (mdf, ndf) can be part of filegroups.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 12:40 am

    #1004434

  • RE: Avg. Disk sec/Read

    TRACEY (6/3/2009)

    So take my results * 1000....why the 1000 sorry being dumb over here.

    Because 1 second = 1000 milliseconds

    Hmmmm the 345 seconds is a big red alarm if < 12...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 4, 2009 at 12:35 am

    #1004431

  • RE: Statistics Update on Alter Index Rebuild/Reorganize

    Statistics are updated (with fullscan) for an index when that index is rebuilt. Not when it is reorganised.

    Reference: Books Online

    http://technet.microsoft.com/en-us/library/ms190397.aspx

    Operations such as rebuilding, defragmenting, or reorganizing an index do not...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 3, 2009 at 3:57 pm

    #1004322

  • RE: Easy question. I lost some of my sql and my stored proc is not working.

    That looks OK. Does it run?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 3, 2009 at 3:17 pm

    #1004309

Viewing 15 posts - 38,671 through 38,685 (of 49,552 total)