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 |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-06-23 : 02:37:07
|
| Hi allThe scenario is as follows..I have a server with the following configCPU-3Ghz2GB RAMDatabases in the serverA1LD-6GBand all the reamaining databse sizes altogether will be 3GBwhen QA team is running test scripts on A1LD,Sqlserver process is taking 1GB of RAM..which never used to take this much of memory before..Now the Test scripts are taking so much of time to complete...the server is very slow..May i know how can i resolve this issue...Thanks |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-23 : 03:26:19
|
| Can you post the script and the DDL of tables?May the Almighty God bless us all! |
 |
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-29 : 16:41:17
|
| 1. check the load (sp_who2, profiler).2. create a baseline when no one is using the server. 3. find out who's query or what exactly is causing the problem. when you pinned down what exact (or primary candidate) causing the sluggish performance (i.e. query), you can then paste the code along with the ddl and sample data so we can help you more.May the Almighty God bless us all! |
|
|
|
|
|
|
How can i resolve it....