Forum Replies Created

Viewing 15 posts - 6,811 through 6,825 (of 49,552 total)

  • RE: Database size increase

    paul.farnell (1/12/2015)

    8000MB

    How does that logic work then ?

    The size of a database is the sum of the size of all data and log files it has.

    One data file of 20...

    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

    January 13, 2015 at 1:41 am

    #1769722

  • RE: Row index and Row number

    There's no such thing as a 'row index' in SQL. Did you mean an identity column? Something else?

    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

    January 13, 2015 at 1:34 am

    #1769719

  • RE: Database size increase

    What's the size of the transaction log?

    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

    January 12, 2015 at 7:34 am

    #1769501

  • RE: Performance issue due to database mirroring?

    2*network latency *per transaction*, which results in locks being held longer, which can cause blocking problems, etc, etc, etc.

    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

    January 12, 2015 at 7:01 am

    #1769488

  • RE: Performance issue due to database mirroring?

    There could also be some effects from the write latency if the log file on the mirror is slow.

    When you have synchronous mirroring, the minimum duration for a transaction is...

    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

    January 12, 2015 at 6:45 am

    #1769479

  • RE: Differential backup pushing a full backup?

    And don't use the Profiler GUI.

    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

    January 12, 2015 at 6:16 am

    #1769472

  • RE: Performance issue due to database mirroring?

    No.

    http://msdn.microsoft.com/en-us/library/ms189061.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

    January 12, 2015 at 6:06 am

    #1769465

  • RE: Differential backup pushing a full backup?

    Benki Chendu (1/12/2015)

    Just to give you an example, I had a full backup which completed by 1:00 AM and ran a differential backup in sometime which completed by 7:00 AM.

    Within...

    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

    January 12, 2015 at 4:41 am

    #1769442

  • RE: SQL 2008 R2 Enterprise downgrade to SQL 2008 R2 Standard

    Edition downgrades are possible for a database. It's version downgrades that aren't

    However it's not something you can do by running the installer and selecting a different version. You will 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

    January 12, 2015 at 4:31 am

    #1769438

  • RE: VERY SLOW PERFORMANCE OF SQL 2000 USING A VIRTUAL MACHINE

    Jeff Moden (1/11/2015)

    If you have a 1.3TB database running on SQL Server 2000, I'm thinking it's time to bite the bullet, upgrade the server, and upgrade SQL Server.

    I'd second 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

    January 12, 2015 at 3:43 am

    #1769430

  • RE: dbcc dbcc show_Statistics question

    Then statistics had not been updated since data had been added to the table.

    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

    January 9, 2015 at 7:22 am

    #1769075

  • RE: Script to findout old prcesses in sql 2008 R2

    No. But if you're trying to tune overall workload, looking at just connections is not going to give you sufficient information.

    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

    January 9, 2015 at 6:06 am

    #1769047

  • RE: Script to findout old prcesses in sql 2008 R2

    That's not tracked by default. You'll need to implement some form of monitoring or auditing.

    But if you're trying to track performance, looking at connections isn't necessarily the way to go....

    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

    January 9, 2015 at 5:28 am

    #1769037

  • RE: Script to findout old prcesses in sql 2008 R2

    You're looking for current sessions which have been connected a long time, or every single connection which has been made since a particular date?

    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

    January 9, 2015 at 5:13 am

    #1769032

  • RE: Correlated Subquery?

    Try it and see?

    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

    January 9, 2015 at 5:10 am

    #1769029

Viewing 15 posts - 6,811 through 6,825 (of 49,552 total)