MS SQL Server - tune vb app

Author

tune vb app

Andy

2006-10-24, 6:38 pm

I'm running sql7.0 sp3 on a N/T box. I have a VB app(vb6) that uses an ODBC
connection to access the database. Most of the code within the app uses
in-line SQL statements and a few SP's are called. I have one location that
always says the app is slow. What can I do from the SQL side to help
pin-point the problem they are seeing. I have used the Profiler but it
proves to be inconclusive to what is causing the slow-ups.

Is there anything else I can monitor or turn on to help determine the
cause.

Thanks.

Andrew J. Kelly

2006-10-24, 6:38 pm

It could be lots of things. Maybe these will help narrow down the culprit.

http://www.sql-server-performance.c... ce_audit10.asp
Performance Audit
http://www.microsoft.com/technet/pr...operations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c.../> ce_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d...erfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types

Tempdb in 2005:
http://download.microsoft.com/downl...gWithTempDB.doc

Physical Database Storage:
http://download.microsoft.com/downl.../PhysDBStor.doc

--
Andrew J. Kelly SQL MVP

"Andy" <Hoosbruin@kconline.com> wrote in message
news:xNqdnXBKqcZj_a7
YnZ2dnUVZ_t6dnZ2d@kc
online.com...
> I'm running sql7.0 sp3 on a N/T box. I have a VB app(vb6) that uses an
> ODBC connection to access the database. Most of the code within the app
> uses in-line SQL statements and a few SP's are called. I have one location
> that always says the app is slow. What can I do from the SQL side to help
> pin-point the problem they are seeing. I have used the Profiler but it
> proves to be inconclusive to what is causing the slow-ups.
>
> Is there anything else I can monitor or turn on to help determine the
> cause.
>
>
> Thanks.
>

Sponsored Links