Forum Replies Created

Viewing 15 posts - 30,826 through 30,840 (of 49,552 total)

  • RE: lastwaittype as PAGEIOLATCH_SH

    PageIOLatch is a wait for a page to be fetched from disk to memory or memory to disk. Lots of them usually indicate poor IO performance. Restarting the instance will...

    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

    September 9, 2010 at 4:41 am

    #1218483

  • RE: SQL 2000 table performance

    ashish.kuriyal (9/9/2010)

    ok, so you mean if the isolation level is not the read commited then he will not have any performance issue

    That's not what I said at all.

    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

    September 9, 2010 at 4:32 am

    #1218480

  • RE: SQL 2000 table performance

    Are there specific queries that are slow? Check and see if they can be optimised.

    Try updating statistics (with fullscan) see if it makes any difference.

    p.s. There are SQL 2000 forums...

    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

    September 9, 2010 at 4:30 am

    #1218477

  • RE: SQL 2000 table performance

    ashish.kuriyal (9/9/2010)

    Also what is the isolation level of the database/server?

    ??

    Isolation level is a connection-level property. Servers and databases don't have isolation levels, connections do.

    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

    September 9, 2010 at 4:27 am

    #1218475

  • RE: Index

    Without knowing the queries that run against those tables, there's no way to make sensible suggestions on indexes. Take a look at the queries that run frequently against the tables...

    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

    September 9, 2010 at 4:26 am

    #1218474

  • RE: query updation

    Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    September 9, 2010 at 2:28 am

    #1218436

  • RE: SQL Server Native Backup with 2000 Databases

    Reo (9/9/2010)

    But problem is that sometime this script takes Full Backup of all database but some time it not. and also it completed within 7 Minutes without any error. but...

    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

    September 9, 2010 at 2:25 am

    #1218434

  • RE: Percentage Utilization of Log file

    Sudarsan Srinivasan (9/9/2010)

    Is it fine to shrink the log file to the bare minimum and expect some positives on the performance?

    No. A large log file (and yours is 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

    September 9, 2010 at 1:56 am

    #1218421

  • RE: No Backward compatibility for 2008 rdl to 2005 version

    Unlikely. It's not a bug.

    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

    September 9, 2010 at 1:54 am

    #1218419

  • RE: SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Huh?

    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

    September 9, 2010 at 1:52 am

    #1218418

  • RE: memory not releasing

    kommagoni (9/9/2010)

    I am not able to identifing the problem from last 5 hours the memory consumes 7.22 Gb, not releasing the memory,

    Once more with feeling....

    SQL does not and will...

    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

    September 9, 2010 at 1:48 am

    #1218416

  • RE: Database stuck in RECOVERING state

    John Sinclair (9/9/2010)

    If the DB was on a USB Flash drive (which sounds like a dodgy idea to me....) then you don't need to defragment it. Fragmentation is an...

    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

    September 9, 2010 at 1:46 am

    #1218414

  • RE: Does Database Mirroring N Log Shipping UNAVAILABLE in SQL Server 2008 R2 STANDARD EDITION

    What attachment?

    What's the recovery model of the DB?

    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

    September 8, 2010 at 11:22 pm

    #1218369

  • RE: Is it possible to avoid SQL Server Logging?

    You cannot disable logging. You can change when SQL removes inactive log records from the log by changing the recovery model. Before you do that, understand the implications if this...

    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

    September 8, 2010 at 11:18 pm

    #1218367

  • RE: fix fragmentation sql server

    Rebuild all indexes.

    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

    September 8, 2010 at 11:17 pm

    #1218365

Viewing 15 posts - 30,826 through 30,840 (of 49,552 total)