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 |
|
vasko
Starting Member
1 Post |
 Posted - 2011-08-25 : 17:47:33
|
| Hi pals,i have very huge problem. I have two servers: 1. test server, windows 2003 32 bit, sql server 2008 32 bit2. production server, windows 2008 64 bit, sql server 2008 64 bitWhen i publish asp.net application (.NET Framework 4.0) on my test machine it works perfect, but when i do it on production machine asp.net application perfomance slow down extremely. Example: when i edit record and open form on page it opens in 3 seconds, but when i do it on production server (same record same page) it opens in 20 sec.Did you have similar problem and how did you solve it?thanx in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-08-26 : 03:28:18
|
| Before doing any performance comparison (e..g between TEST and PRODUCTION) I would ensure that all indexes and statistics were rebuilt on both systems. Otherwise it will be like comparing Apples with Oranges! |
 |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-08-26 : 09:10:10
|
| Another thing would be to Determine if the problem is actually the Database. You mention it is slow through a Form in the App.. It could be the App.You need to get some query times. You may need to use SQL Profiler but be cautious running it on Production. |
|
|
|
|
|
|
Slow perfomance