Thread: Server Performance
04-23-12, 04:37 #1Registered User
- Join Date
- Apr 2012
Unanswered: Server Performance
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?
CPU: Quad Core(2 cpu, 8 core)
OS: Windows 2008 (32bit)
SQL Server: 2005 Standard Edition
04-23-12, 05:25 #2Registered User
Provided Answers: 2
- Join Date
- Apr 2008
- Iasi, Romania
You should start by learning and using some tools, like: Windows System Monitor, SQL Server Profiler, SQL Server Activity Monitor. They will show you what's happening in your server.Florin Aparaschivei
DB2 9.7, 10.5 on Windows