SQL Server Performance Forum – Threads Archive

Timing Out

Over the weekend, I upgraded a SQL 2k (Win 2k) server to sp3a and I also changed the account that the SQL services start under. This server also has a SQL 3rd party app (web/intranet) that has it’s own set of SQL services. As of today, the app starts, but times out when logging in. I am in the middle determining if the sp and service changes have anything to do with the time-outs. I have not seen anything in the SQL knowledge base regarding this. I hestitate to call the software vendor, as support for this product is not good. So it is up to me to investigate, well, it is faster if I investigate than wait for support. I have changed the services back to using system accounts to log in, and there is still a problem. This leaves the sp install as a possible cause. I have not ruled out that it is the app itself, as this happened in the past when there had been no changes. My feeling is that there will still be an issue even if I uninstall the sp – which I really do not want to remove. But I have to at least attempt to fix this! Does anyone have any general suggestions what else I might check? Thanks to all in advance for any and all suggestions!
Karen SQLGoddess
Life is one fool thing after another whereas love is two fool things after each other.â€” Oscar Wilde

Perform the following :
-Recompile all the stored procedures.
-Run UPDATE STATISTICS manually on the heavy tables.
-Schedule DBCC DBREINDEX on most used tables. Above all ensure there are no network issues between application and SQL server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Yes, thanks, will do. As far as any logged errors, there are no clues in SQL logs or in Event Viewer. It will probably turn out to be the app, and nothing I did, but I must at least try! <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> SQLGoddess Life is one fool thing after another whereas love is two fool things after each other.â€” Oscar Wilde

If its a third party developed application, then schedule the above tasks periodically. If its a in-house developed then try to fine tune the queries with the help of PROFILER etc etc. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya, Yes, it is a third party app. I was going to run profiler next to see if I can find any clues. I kinda threw this question out here because here and there in the kb, it mentions net(web) issues with sp3 – such as msxml versions, etc. I did not know if any of these things would "cause" the app to time out when logging in. I love my job, except when something seems unresolvable or resolves itself…. lol <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> Karen SQLGoddess Life is one fool thing after another whereas love is two fool things after each other.â€” Oscar Wilde

If you find any query to taking to much CPU or Input/output, and that query use auxiliary tables, remember that Profiler or ITW can understand auxiliary tables.
Example: insert into #aux (select …….).
If you want to tuning, take from select to end, paste in SQL Analyzer and see execution plan or ITW. Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

PROFILER is the handy tool to findout the query timeouts and if the timeout is occuring on the application level then make sure no network issues or firewall authentication etc. Refer the KBAhttp://support.microsoft.com/default.aspx?kbid=823490 (I think same as mentioned by you) and try to get the the referred files. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks to all for input! Last night I re-applied the sp and no problems today. The sp periodically gives me problems when installing…
SQLGoddess
Life is one fool thing after another whereas love is two fool things after each other.â€” Oscar Wilde

Then schedule a SP_RECOMPILE job on involved SPs to fine tune the SP performance. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Satya, Have done that already, thanks for the suggestion. What prompted the sp update in the first place is the SQL server in question also has a SQL instance which I have been trying unsuccessfully to upgrade. It is my understanding that the instance also needs to have the sp upgraded (sql2ksp3desk). I have had questions on this on the MS support sites, since I have had difficulty upgrading the instance. If the sp doesn’t fight me, the instance does… lol Thought I finally accomplished it this past weekend, guess not. I thought the install went too smoothly!! lol It looks like the desksp installed over the main SQL and not the instance that I thought I selected. Definitely my fault, I should have caught that. I guess I was too anxious to go dancing…. <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> I reinstalled sp3 to the main SQL and everything works. I just don’t like that the instance has not been upgraded. We have enough problems with the 3rd party app, and I was hoping the sp would help, plus I want all SQLs to be consistent. I am back to square one. And I won’t be able to get back to this until the weekend. The instance may never be updated! Thanks to all! SQLGoddess Life is one fool thing after another whereas love is two fool things after each other.â€” Oscar Wilde

]]>