Hey all. I have a client who is running into some sporadic but severe and frustrating performance issues on a VFP 9 app connecting to a SQL Server box.
The SQL Server box is their primary office server , also running Exchange. Lots of disk space but only 1 GB of RAM. As I mentioned, it IS sporadic - I can't really see anything from the Performance tuner - sometimes some queries get suspended but then run again.. The application itself has data stored on another server and was working fine before switching to the SQL version. I've increased the size of tempdb. The database is spread into two main files but has tons of space free (it's got a size of 1 GB with 600 MB free). Any suggestions on where to look for those items killing performance? Thanks Andrew _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
