Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sql Server cpu usage & VB 6.0

0 views
Skip to first unread message

George Kalfoglou

unread,
Jun 11, 2001, 5:13:00 AM6/11/01
to
Hi

I have noticed that when a query is executed from a VB 6.0 program, sql server
consumes much more cpu time than running the same query from server analyzer.

Do you have any idea ?

Thanks

Tibor Karaszi

unread,
Jun 11, 2001, 6:31:04 AM6/11/01
to
Perhaps VB use using a cursor? Use Profiler to track down the difference.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

"George Kalfoglou" <geo...@icap.gr> wrote in message
news:5cae01c0f256$b6878d60$a5e62ecf@tkmsftngxa07...

0 new messages