Forum Replies Created

Viewing 15 posts - 14,101 through 14,115 (of 49,552 total)

  • RE: Adding an extra file to TEMPDB

    You don't need to correct the situation where one of more of the files has expanded because on restart of SQL the files will be back to their defined size....

    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 28, 2013 at 10:37 am

    #1592099

  • RE: Removing a secondary tempdb file

    What was the initial, defined size of the first file before you ran that?

    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 28, 2013 at 10:31 am

    #1592098

  • RE: Adding an extra file to TEMPDB

    Robert Davis (2/28/2013)

    GilaMonster (2/28/2013)

    Regarding point number 4 above. Is a reboot necessary - could i just restart the sql server agent ?

    No reboot necessary. Not SQL agent though, restart SQL...

    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 28, 2013 at 10:28 am

    #1592095

  • RE: Removing a secondary tempdb file

    Should work.

    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 28, 2013 at 6:03 am

    #1591954

  • RE: Removing a secondary tempdb file

    TRy a shrinkfile with emptyfile, then remove the second file.

    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 28, 2013 at 4:59 am

    #1591934

  • RE: MCTS 70-448 expiring in July 2013

    Perry Whittle (2/28/2013)

    Koen Verbeeck (2/28/2013)

    This certification doesn't really "expire".

    Once the product reaches end of life it expires

    The certs don't expire (well, not the MCTS/MCITP ones). The exam is retiring...

    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 28, 2013 at 4:08 am

    #1591927

  • RE: database security

    However bear in mind that anyone who is an administrator on the machine that runs SQL can remove the TDE and decrypt any column encrypted by key or cert 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

    February 28, 2013 at 3:28 am

    #1591919

  • RE: Page life expectancy diving to sub-10 on a 128 GB server

    No server options that could cause this. Probably CheckDB or index rebuilds that move a huge amount of data through the cache.

    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 28, 2013 at 2:15 am

    #1591908

  • RE: Multiple Transaction Logs, will removing one break Log Shipping?

    You'll only be able to remove it if all the VLFs in that log file are inactive (not needed for anything). If they're not, you'll have to wait and 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

    February 28, 2013 at 2:13 am

    #1591907

  • RE: Adding an extra file to TEMPDB

    stehoban (2/27/2013)

    Regarding point number 3 above. How to i reduce the size from 1.5gb to 800mb or 1gb ? Would this be by using the ALTER database command with the...

    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 28, 2013 at 1:52 am

    #1591901

  • RE: Low Performance - High CPU Problem and others...

    SQL Pizza (2/28/2013)

    I just asked myself, if there is a point, where you can't optimize queries and indexing anymore, cause it's just to much workload for the cpu to handle...

    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 28, 2013 at 1:49 am

    #1591900

  • RE: Adding an extra file to TEMPDB

    ScottPletcher (2/27/2013)

    GilaMonster (2/27/2013)

    ScottPletcher (2/27/2013)

    Then, set up a start up proc to shrink both tempdb files ... I'd say to 1G each, so you have some cushion. You really don't...

    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 28, 2013 at 1:46 am

    #1591899

  • RE: Adding an extra file to TEMPDB

    ScottPletcher (2/27/2013)

    Then, set up a start up proc to shrink both tempdb files ... I'd say to 1G each, so you have some cushion. You really don't ever want...

    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 27, 2013 at 1:53 pm

    #1591723

  • RE: Need to increase log file size permanently.

    You either have auto_shrink on or you have a scheduled shrink job. Get rid of the shrink and the file will stay at the specified size (or will grow if...

    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 27, 2013 at 11:24 am

    #1591664

  • RE: Quick Index/Statistics Question

    Basically this on a weekly, bi-weekly or monthly basis.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 27, 2013 at 10:12 am

    #1591635

Viewing 15 posts - 14,101 through 14,115 (of 49,552 total)