May 13, 2011 at 2:24 am
:w00t:
The App is named isalon, when doing report/analysis for one month, it takes very long, 15/20 mins, sometime you have to wait forever,
I check the computer, it is working normally without doing report/analysis, when
I was doing the report, then the sqlservr.exe takes nearly 100% CPU usage, and takes too long.
but If I choose one day report, it is not very slow, takes 30 seconds.
The SQL 2005 express is on sp1, I have few question:
1. does sp4 can solve the problem?
2. if I install sp4, does effect existing data?
Do you have any other suggestions?
May 13, 2011 at 11:08 am
Update from SP1 to SP4. This will not effect the existing data but you should perform in DEV & QA as well as perform UAT.
http://support.microsoft.com/kb/913089
Does SP4 correct the problem?
Need additional information to make that determination.
The following articles are not for SQL Server Express but they may provide you with some information needed to troubleshoot this problem:
http://social.msdn.microsoft.com/Forums/en/tfsgeneral/thread/efc36f39-f034-4ed0-b62c-b3a1f656e4fd
http://support.microsoft.com/kb/915308
http://sql-server-performance.com/Community/forums/p/5862/20200.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 11:10 am
aaapppleee (5/13/2011)
:w00t:The App is named isalon, when doing report/analysis for one month, it takes very long, 15/20 mins, sometime you have to wait forever,
I check the computer, it is working normally without doing report/analysis, when
I was doing the report, then the sqlservr.exe takes nearly 100% CPU usage, and takes too long.
but If I choose one day report, it is not very slow, takes 30 seconds.
The SQL 2005 express is on sp1, I have few question:
1. does sp4 can solve the problem?
2. if I install sp4, does effect existing data?
Do you have any other suggestions?
sp is a good idea to have, but certainly not the most obvious fix.
Can you post the query along with the actual exectution plans that make the cpu spike?
May 13, 2011 at 11:25 am
You may want to provide the Scripts for the Tables and indexes etc.
Does the report run slow consistently? Are there any other processes that are interfering with the Report?
How many records are in the tables?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 12:28 pm
Thanks a lot!
I will read the ref you gave
May 13, 2011 at 12:32 pm
sometime the speed is better, especially after restart the computer,
ok, This is my friend's salon, they have the salon management software named: isalon.
They are very busy every day.
If I do one day report for the sales, it's not bad speed, still take 15/20 seconds.
But If I do one month report, then I have to wait long time....
May 13, 2011 at 12:35 pm
Second thought the links that I provided you do not address the probable cause of your applications performance issue.
You should probably focus on the execution plan, etc,
Could you provide additional details to include schema, number of record per table, fragmentation, etc?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 12:39 pm
thank you for your help. :-DI'm not in the salon now. and It is in another city, next week I might have chance to go there.
May 13, 2011 at 12:42 pm
and I don't know about the database thing actrually:cool:, is there any program can do the optimization for the sql 2005 ?
May 13, 2011 at 1:50 pm
There a number of tools that can be used for optimization.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 1:52 pm
🙂
Could you please give a list?
Which one is safe to use and efficient?
and is it good for me who don't know database:-)
May 13, 2011 at 2:05 pm
There are a lot of tools but it takes a little more than that.
I have listed two tools that may be helpful but it will not be enough but hopefully it will help.
http://www.red-gate.com/products/dba/sql-monitor/
http://www.quest.com/sql-server/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 2:08 pm
Thanks a lot:-)
May 13, 2011 at 2:49 pm
aaapppleee (5/13/2011)
Thanks a lot:-)
No offense but if you have no experience don't play with it. I wouldn't do brain surgury on my friends and I don't think anyone unqualified should either.
Call in a pro for some help.
May 13, 2011 at 2:56 pm
He insist, so I have to try it for him.
I will create a disk image for system first. then going to find the trick.
I won't do any brian surgery for any of my friends, because I know I can't put it back,
but simply, I can recover the whole computer system back to original condition.
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply