Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sels2005j
Starting Member
1 Post |
 Posted - 2011-07-10 : 00:18:49
|
| We are using an application software made in VB6 and SQL 2005. My server has 12 GB RAM and 6 GB AWE Maximum memory. But some stored procedures are very slow to process and get request time out error message.How can I increase the performance of my application or SQL server. How much maximun memory can I give for AWE out of 12GB server physical memory.Please help. It is very urgent. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-10 : 03:54:45
|
Check Execution Plan to see what to fix.If necessary, add proper indexes.Check and refactor your code to NOT use cursors.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-10 : 06:12:36
|
| [url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-07-10 : 06:28:20
|
| For general guidance leave at least 2 GB for OS , and depending on what other services you are running, leave more memory for the OS. This will depend on other factors , such as 32 bit or 64 bit . Check for my notes: http://www.sqlserver-dba.com/2010/10/sql-server-2005-memory-configuration-management.html For stored procedure issue - focus on the execution plan . Investigate the code and ensure , the code is exploting the indexes. Ensure the statistics are up to date Consider posting the execution plan - and we can analyseJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Jason W
Starting Member
19 Posts |
Posted - 2011-07-10 : 09:58:07
|
| If you are looking to understand the basics of optimizing individual procedures, check out this site:www.sqloptimizationsschool.comIt will take you through all of the introductory items (reviewing execution plans, making modifications to procedures/tables, etc)Jason |
|
|
|
|
|
|
Increase Stored Procedure Performance