Im using ms sql servers clustered, it is the backend for my web data. When the link from the web server is broken by stopping the lasso service and restarted, it takes up to 30min for the pages to pull the data from sql with decent response time (2-3 seconds) until them it may take 30-40 seconds to pull the data for the page. Any one have a clue as to why this would happen?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Response slow but gradually gets faster 1
- Thread starter snobleky
- Start date
What is the 'lasso service'??
If a service on the cluster is stopped, it might be causing everything to failover. Depending on your setup, this might not be happening instantly. Some parts might be failing over before others and SQL Server might be taking a while to figure out that it needs to failover. Or your queries may be happening before the failover is complete.
I would start looking to see if a failover is happening. Have your sysadmin and/or DBA watch the cluster to see if a failover occurs and how long it takes for everything to come up.
-SQLBill
If a service on the cluster is stopped, it might be causing everything to failover. Depending on your setup, this might not be happening instantly. Some parts might be failing over before others and SQL Server might be taking a while to figure out that it needs to failover. Or your queries may be happening before the failover is complete.
I would start looking to see if a failover is happening. Have your sysadmin and/or DBA watch the cluster to see if a failover occurs and how long it takes for everything to come up.
-SQLBill
- Thread starter
- #3
Thanks for the info.
Lasso service runs on my web server and is used to pull the data from the sql server to the web pages. When this service is stopped and restarted on the web server for things like maint to the data base, then performance becomes very slow for about 30 min.
One note: the failover sytem doesnot have a cluster just the web server and sql, it doesnot have this problem.
Lasso service runs on my web server and is used to pull the data from the sql server to the web pages. When this service is stopped and restarted on the web server for things like maint to the data base, then performance becomes very slow for about 30 min.
One note: the failover sytem doesnot have a cluster just the web server and sql, it doesnot have this problem.
-
1
- #4
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
Is it not down to pages being cached into memory? Like restarting the server slows performance as you lose all of your cached pages.
James Goodman MCSE, MCDBA
James Goodman MCSE, MCDBA
- Thread starter
- #5
Thanks for the reply I thought about that too, but I'm not sure I follow you on this, the server is not restarted just the service. We do the same process on our failover system that doesnt use the cluster and it doesnt have the same problem.
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
Hmm,
So if you restart the service & dont use the DB for 30mins the response would be ok?
Or does the DB need to be used in order to improve performance?
James Goodman MCSE, MCDBA
So if you restart the service & dont use the DB for 30mins the response would be ok?
Or does the DB need to be used in order to improve performance?
James Goodman MCSE, MCDBA
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question