Performance of application ?
in [Server Configuration]
|
From: Eng Teng on 2 Jul 2008 10:36 Will the increasing of database size affect the performance of application ? Where can I get more information to improve performance of application ? Regards, Tee
From: Uri Dimant on 2 Jul 2008 10:50 Hi http://www.sql-server-performance.com/ "Eng Teng" <engteng(a)gmail.com> wrote in message news:O0tR4DF3IHA.2336(a)TK2MSFTNGP03.phx.gbl... > Will the increasing of database size affect the performance of application > ? > > Where can I get more information to improve performance of application ? > > Regards, > Tee
From: Plamen Ratchev on 2 Jul 2008 10:54 Properly designed database and application code should not be affected much by size increase. Of course, depends on how much is the increase, if increased with TBs then it may differ. Here are a few articles and resources on performance tuning and troubleshooting: http://www.sql-server-performance.com/articles/per/SQL_Server_Performance_Coding_Standards_p1.aspx http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx Also, the Best Practices site has lots of useful scripts and articles: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx HTH, Plamen Ratchev http://www.SQLStudio.com
From: TheSQLGuru on 2 Jul 2008 11:12 Most effective thing you can do both for yourself AND your application performance, is to hire a professional to give you a performance review and mentor you in how to do the investigation and mitigation. Self study using one of several sql server performance tuning books will obviously help as well. -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "Eng Teng" <engteng(a)gmail.com> wrote in message news:O0tR4DF3IHA.2336(a)TK2MSFTNGP03.phx.gbl... > Will the increasing of database size affect the performance of application > ? > > Where can I get more information to improve performance of application ? > > Regards, > Tee
|
Pages: 1 Prev: Memory allocation question Next: MSSQL code to find all records within 1 year |