Wireless Networks Thread, Sql Server & possible network issue in Technical; Hi all.
We have in our organisation an application which has been running for years, and suddenly over the last ...
13th November 2009, 10:22 AM #1
- Rep Power
Sql Server & possible network issue
We have in our organisation an application which has been running for years, and suddenly over the last month or so it's been steadily grinding to a halt.
Simple queries (two in particular to be precise) which take seconds to run in QA, sometimes take hours from the application front-end.
One is so simple.
Select column a, b, c, d from table 1 order by column a desc.
The second is just a plain ordinary select a, b, c, d from table 1.
On each occassion it's the same table 1.
As far as I am aware no upgrades or changes have been made to the DB or front-end application in the past year or so.
I have so far reindexed the DB, checked with index tuning wizard (no issues found there), checked the server, that appears to be running ok, no additional stress there.
We see some blocking against that particular DB, but mostly long running queries.
The sql server back-end has other DB's on it, but non of the customers are complaining about those.
Not sure what else i could try on this occassion.
IDG Tech News
14th November 2009, 10:52 PM #2
You say that you get blocks occuring and that application performance is sometimes poor . . . .
Have you checked to see if these coincide? If a query is locking resources then it wouldn't be a surprise that the app was hanging around waiting for data .
By UkDraxion in forum Wireless Networks
Last Post: 10th November 2009, 11:37 AM
By FN-GM in forum Thin Client and Virtual Machines
Last Post: 15th July 2009, 02:09 AM
By ahunter in forum Virtual Learning Platforms
Last Post: 31st October 2008, 01:19 PM
By contink in forum Windows
Last Post: 14th May 2008, 03:56 PM
By tscnmuk in forum MIS Systems
Last Post: 20th July 2007, 01:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)