AV Scans often cause this. Also replication or other jobs scheduled in SQL Server.
Regards Michael Hawksworth > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:profoxtech- > [EMAIL PROTECTED] On Behalf Of Andrew MacNeill > Sent: 19 July 2007 13:35 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: VFP / SQL Performance and Configuration > > 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 > > [excessive quoting removed by server] _______________________________________________ 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.
