Re: BDL Performance Testing

Richard,

I'm no SQLServer expert, but the Engine itself may have a diagnostic
facility for showing SQL statements, costs, etc.

Joe

At 03:16 PM 2/24/2005, Richard Turner wrote:
>Hi All,
>
>Does anyone know of a tool or utility I can use to view the database
>costs a 4GL encounters when the program is executed against a SQL Server
>database?
>
>On Informix systems, I would normally use a "set explain" command in the
>4GL then, once I executed the program, I can go back and view the ascii
>file sqexplain.out.  This was very handy since it recorded all SQL
>statements made by the 4GL and it would state whether it did a
>sequential search, used an index etc.  It would also give you an
>estimated database cost for that sql statement.
>
>I would like to, at minimum find a way to determine if indexes are being
>used or not.  Basically, I have a very large program that runs quickly
>on an Informix database BUT, when I run the same code against SQL
>Server, it crawls at a snails pace.  Equally as bad, it seems to be
>eating up most of the CPU cycles on the server so most everything else
>grinds to a halt too.  I suspect a sequential table scan is happening
>but can't quite put my finger on it.  I've briefly experimented with
>FGLSQLDEBUG but it doesn't seem to give me the index or cost information
>I need.
>
>Any ideas would be much appreciated.
>
>Thanks,
>
>
>Richard

Joe Lewinski
ICANON Associates, Inc.
Phone: 215.822.5519 Fax: 215.822.5523

NEWZware is a product of ICANON Inc. - Visit our web site at
http://www.icanon.com/ for more information on ICANON, the company, and its
suite of products and services.