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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-07-21 : 12:37:09
|
| Hi,I have scenario here related to performance problem.I need to figure out, where is the problem lies?1. Is that the problem from the sql server side?2. Is that the problem from the memory of database server?3. Is that the problem of the Web server machine?4. Is that the problem with application problem?5. Is that the problem with the Page file sizing?6. Is that any looping of the rows in the front - end which is taking time.Meaning, sometimes they l get all the required result to the front end -web server and run the loop for the result set and start writing row by row in xml format?7. Is that tempdb issue?I need a step from where i can start troubelshooting the problem.Basically, the application all it does is it pull the data from sql server and writes in EXcel format i.e. exxport functionality.It used work fine for exporting data upto 500 records very fine.But now the there s no limittation of records to write to the xml file. number of records to be written in xml format can be upto 5000 records.Oservation.--------------1.on database server , checked sp_who2. Nothing is being run. the proccess initiated this ccommand is AWAITNG COMMAND status.2. Checked the task manager , on database server i could nt find that much load.3. On the web-server, when i looked into the task manager , and processes tab, it is showing dllhost.exe is being increased more than 1 GB memory. and system is getting hanged? what is that dllhost.exe? when does it come into picture normally?4. On web server , RAM is 2 GB and max PAGE File size is 4 GB?5. OS is Windows 2003 Server Enterprise edition,sp2 6. SQL Server 2000 Standard edition, sp4 How to figure out, where does the actual problem lies which is affecting the overall performance of the export application???Any suggestions would be greatly appreciated. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
|
|
performance tuning