Query Analyser 'responce time'

[cjb110]

I have a SQL Server 2000 program which has logging sp which writes a record to a table and also print of that record. i.e. we can run the program in QA and see what its doing. However QA only updates every so often...is there a way we can make it update more regularly? It just to help with testing/development. In production a GUI sits on top.

[Corporal Agarn]

Instead of the print try populating a table that a second QA session can access and query that while the sp is running. You could try linking SQL 2008 Express and running from there as 2008 reports back more often. Another trick is to put in "timestamps" on your print so you can tell where things are taking so long. As you can tell tuning is not my specialty, so I hope one of these helps or someone comes up with a better idea. Good Luck.