Forum Replies Created

Viewing 15 posts - 10,036 through 10,050 (of 49,552 total)

  • RE: Page life expetancy is low

    Benki Chendu (2/12/2014)

    GilaMonster (2/12/2014)

    Benki Chendu (2/12/2014)

    Gila - I would need help in showing my client a document which says 5000 is an agreed value. I can then convince them to...

    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

    February 12, 2014 at 11:22 am

    #1688521

  • RE: Lock escalation

    jungnaja (2/12/2014)

    When I use run select statement, it's about 1K logical reads, and 0 physical reads

    So that's 1000 pages read to get the 10 rows. If it's starting with row...

    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

    February 12, 2014 at 11:21 am

    #1688519

  • RE: Any Advice??

    Now, given that data you just posted, what do you want to happen? What must the end result look like?

    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

    February 12, 2014 at 9:23 am

    #1688455

  • RE: Page life expetancy is low

    Benki Chendu (2/12/2014)

    Gila - I would need help in showing my client a document which says 5000 is an agreed value. I can then convince them to tweak my SCOM...

    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

    February 12, 2014 at 9:21 am

    #1688452

  • RE: Lock escalation

    Does the update use an index? How many does SQL have to read to identify those 10 rows?

    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

    February 12, 2014 at 9:20 am

    #1688450

  • RE: Page life expetancy is low

    Benki Chendu (2/12/2014)

    Current PLE is set at 300 seconds/5 minutes

    Total memory on the instance is 64 GB

    300 is insanely low for that. 300 was a too low recommendation when...

    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

    February 12, 2014 at 9:14 am

    #1688442

  • RE: Foreign Keys: Essential or Academic?

    Eugene Elutin (2/12/2014)

    GilaMonster (2/12/2014)

    Eugene Elutin (2/12/2014)

    ...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be...

    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

    February 12, 2014 at 9:10 am

    #1688432

  • RE: Managing an Extremely Busy OLTP Server

    chandan_jha18 (2/12/2014)

    While this may be a good practice for most of the databases(I have witnessed a lot of similar ones), having an ever increasing key as clustered indexes might be...

    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

    February 12, 2014 at 9:08 am

    #1688429

  • RE: Foreign Keys: Essential or Academic?

    Eugene Elutin (2/12/2014)

    ...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through procedural...

    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

    February 12, 2014 at 9:05 am

    #1688423

  • RE: Foreign Keys: Essential or Academic?

    Essential. Absolutely essential.

    There's no procedural or application code that will stop someone from updating a table directly if they have permissions, or stop a newly written app from putting bad...

    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

    February 12, 2014 at 9:04 am

    #1688422

  • RE: Page life expetancy is low

    Chapter 4: http://www.red-gate.com/community/books/accidental-dba

    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

    February 12, 2014 at 8:52 am

    #1688409

  • RE: Execute large number of insert statements

    Why do you say using the SSMS window will cause lots of blocking?

    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

    February 12, 2014 at 8:46 am

    #1688404

  • RE: How Often Do I Backup my Log?

    EricEyster (2/12/2014)

    This statement may need a bit of an update, or an clause that assumes your only recovery option is via your log backups. If you are using 2012 HA...

    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

    February 12, 2014 at 8:22 am

    #1688383

  • RE: Orphan logins fix

    Windows logins shouldn't be able to be orphaned, their SIDs come from the AD.

    Those logins exist and have matching users on the log shipping primary?

    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

    February 12, 2014 at 8:16 am

    #1688380

  • RE: Orphan logins fix

    Drop the logins. Recreate them with the same SID (security identifier) as they have on the log shipping primary.

    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

    February 12, 2014 at 8:10 am

    #1688372

Viewing 15 posts - 10,036 through 10,050 (of 49,552 total)