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 |
|
csarsonas
Starting Member
1 Post |
 Posted - 2012-04-23 : 03:05:32
|
| Good day to all!I'm new to SQL server environment...right now, we are using it to our client.I would like to check if the server is in the optimize settings or utilizing its cpu cores (8 cores) and memory capacity (8 gig).Scenario is that our web apps (asp.net) is having performance problem.Single user on a particular module will have an estimation of 4-5 sec data retrieval (stored procedure was used to retrieve data). row count of the table is 600,000+ records (optimized with indexes).When we add 2 or more users, data retrieval estimated to 25-30 secs.What should i do to optimize and maximize its performance?Server specs:CPU: Quad Core(2 cpu, 8 core)Memory: 8gigOS: Windows 2008 (32bit)SQL Server: 2005 Standard Edition |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-23 : 03:35:32
|
| You should probably start optimizing the stored procedure(s). A query/procedure that takes 4-5 secs on a table with only 600k records is outrageous... Post the stored procedure here and we can take a look at it.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
|
|
|
Server performance