+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Nov 2009
    Location
    Rotherham
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Angry Sql Server & possible network issue

    Hi all.

    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.

    Cheers.

  2. #2

    Join Date
    Apr 2006
    Posts
    387
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    Hi there

    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 .

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 10th November 2009, 10:37 AM
  2. Network & VMware Server 2
    By FN-GM in forum Thin Client and Virtual Machines
    Replies: 7
    Last Post: 15th July 2009, 01:09 AM
  3. Moodle & SQL Server 2005
    By ahunter in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 31st October 2008, 12:19 PM
  4. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM
  5. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 12:58 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •