Forum Replies Created

Viewing 15 posts - 16,906 through 16,920 (of 49,552 total)

  • RE: How to reduce SQL Server memory usage?

    4096 is most certainly NOT a standard. Please read the chapter that Anthony posted.

    Reducing memory usage will not improve performance. It'll probably degrade performance. SQL uses its memory to 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

    August 28, 2012 at 3:35 am

    #1530654

  • RE: Database Data not saving to the correct MDF Files

    In general SQL Servers shuold not need restarting often. Patches and the like are the exception, but other than those there's no reason to restart a server running SQL Server.

    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

    August 28, 2012 at 3:30 am

    #1530651

  • RE: How to reduce SQL Server memory usage?

    How much memory does the server have and why do you want to reduce the memory usage?

    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

    August 28, 2012 at 3:15 am

    #1530643

  • RE: Database Data not saving to the correct MDF Files

    The data will go into the data files that define the database. So if the test DB uses Test.mdf and you make changes to the Test database, they go into...

    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

    August 28, 2012 at 3:09 am

    #1530639

  • RE: How to reduce SQL Server memory usage?

    And just a note. SQL uses memory in order to cache portions of the database so that it doesn't have to re-read them from disk all the time. It's supposed...

    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

    August 28, 2012 at 3:06 am

    #1530635

  • RE: UPDATE when the values are the same

    MissTippsInOz (8/27/2012)

    I think an update where no update occurs can perhaps being thought of as a logical update. That is, as has already been said, locks are applied 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

    August 28, 2012 at 2:44 am

    #1530627

  • RE: What can i do to improve performance on this scenario?

    There's no silver bullet or go-faster switch if that's what you're looking for (http://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/)

    Profile the data load, identify which parts are slow and work on optimising the bottlenecks. Repeat until...

    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

    August 27, 2012 at 12:55 pm

    #1530477

  • RE: Optimizer using an index that degrades performance!

    I've been told these are good to start with:

    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

    August 27, 2012 at 10:56 am

    #1530436

  • RE: Question on Multi-Instance Clustering

    Databases don't live on nodes. They re on shared storage. The instances run on particular nodes.

    Don't use the term active/passive. It's misleading and out of favour. What you are describing...

    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

    August 27, 2012 at 10:33 am

    #1530428

  • RE: Question on Multi-Instance Clustering

    Clustering is NOT load balancing.

    Any instance on a cluster is active on one node only. It will be stopped on all other nodes. A multi-instance cluster is a cluster with...

    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

    August 27, 2012 at 10:13 am

    #1530418

  • RE: Optimizer using an index that degrades performance!

    Estimated costs are estimated.

    Does it take longer to run (statistics time or profiler duration column)? Does it do more reads (statistics IO or profiler reads column)? Does it use more...

    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

    August 27, 2012 at 10:06 am

    #1530417

  • RE: Backup failed

    (Logon failure: unknown user name or bad password.)

    You're using an account that does not exist on the domain or you're specifying an incorrect password. If you're using a domain account,...

    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

    August 27, 2012 at 9:30 am

    #1530402

  • RE: How can I get all in query result into one view

    Table definitions please?

    As a guess, I'd say join to a calender table and just do a group by on the date. No looping required. http://www.sqlservercentral.com/articles/T-SQL/70482/

    You need a calender table 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

    August 27, 2012 at 8:46 am

    #1530390

  • RE: Is UPDATE FROM only available in SQL 2005?

    It' not part of the ANSI standard. Doesn't mean it's deprecated in any version of 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

    August 27, 2012 at 8:24 am

    #1530373

  • RE: Transparent partitioning.

    I wouldn't go as far as saying it's not for OLTP, for any form of sliding windows where you periodically need to purge older data from a table, it can...

    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

    August 27, 2012 at 8:23 am

    #1530371

Viewing 15 posts - 16,906 through 16,920 (of 49,552 total)