October 1, 2013 at 5:22 am
Hello dear,
in a server i install sql 2000 & sql2008 r2.
and link to another server in sqlserver2000r r2 that have sqlserver2000.
suddenly all application that connect to sqlserver2008 r2 decreased speeds of them.
what happen on?
would you please help me?;-)
best regards,
zohreh
October 1, 2013 at 5:39 am
No where near enough information. We can't see your screen, you're going to have to explain a lot more for anyone to even be able to guess.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2013 at 6:47 am
Hello dear,
ram usage in server is 2.75 of 4G (1.8 used by sqlserver2008 r2)
cpu usage 20 - 50%
all database 'Auto update statistics' is false
but when connect by application (asp classic) to server take 2-3 sec to show data in sample page but
before that it takes less than 1 sec
what additional information you need?
October 1, 2013 at 7:08 am
zsafakhah (10/1/2013)
Hello dear,ram usage in server is 2.75 of 4G (1.8 used by sqlserver2008 r2)
cpu usage 20 - 50%
all database 'Auto update statistics' is false
but when connect by application (asp classic) to server take 2-3 sec to show data in sample page but
before that it takes less than 1 sec
what additional information you need?
The table definitions, the amount of data, the query itself and the query plan might be a good start.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 1, 2013 at 8:06 am
zsafakhah (10/1/2013)
what additional information you need?
As yourself if you could solve a problem with the little information you've given. Ask yourself what you'd want to know if someone asked you about this kind of problem. To start with, the queries that are slow. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
That auto update statistics setting is a problem, I suggest you change that unless you have a complete statistics maintenance job set up yourself.
Oh, and I'm not your 'dear'.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply