RE: Performance Issues

[Chris O]

> Hello all,

> I am having some pretty major performance issues on a certain page of
> mine.  Our site is driven by perl, IIS6, and MS SQL Server.  Does
> anyone have any good tips or tools on finding out what is causing the
> issue, like a profiler that will work on IIS?

> Thanks!

> -fREW

I had similar issues under moderate load. I found that hundreds of TCP
connections were remaining open between IIS & SQL after they should have
been closed. I solved the problem by converting everything to perlEX and
using only a handful of shared connections. The downside is that with perlEX
(same goes for mod_perl), there's no room for sloppy/lazy code.

You can use the free TCPView utility to monitor the connections.
http://technet.microsoft.com/en-us/sysinternals/bb897437.aspx



- Chris

___
Perl-Win32-Web mailing list
Perl-Win32-Web@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: Performance Issues

[Jenda Krynicky]

From: fREW <[EMAIL PROTECTED]>
> I am having some pretty major performance issues on a certain page of
> mine.  Our site is driven by perl, IIS6, and MS SQL Server.  Does
> anyone have any good tips or tools on finding out what is causing the
> issue, like a profiler that will work on IIS?

I bet your database doesn't have a single index. That's the most 
common problem. Incorrectly designed database missing indexes and 
insanely inefficient queries.

Try to run the SQL Server Profiles (from MS SQL Server / Performance 
tools) for a bit and see how long do queries take. Then look in Query 
Analyzer or Management Studio at the estimated execution plan of the 
query that took so long.

If you see Table or Index Scans even though the queri is supposed to 
return just a few of the rows, you are missing indexes. Add indexes 
on the columns you search by.

Jenda
= [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =
When it comes to wine, women and song, wizards are allowed 
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery

___
Perl-Win32-Web mailing list
Perl-Win32-Web@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Re: Performance Issues

[Bill Luebkert]

fREW wrote:
> Hello all,
> 
> I am having some pretty major performance issues on a certain page of
> mine.  Our site is driven by perl, IIS6, and MS SQL Server.  Does
> anyone have any good tips or tools on finding out what is causing the
> issue, like a profiler that will work on IIS?

You could start by timing the script and seeing how long it takes.

I would first open a log file and then add the log file's FH to the
prints below or do something similar:

our ($pt0, $timeit); BEGIN { $timeit = 0; } # time the script
BEGIN { if ($timeit) { print scalar (localtime), "\n";
  $pt0 = Win32::GetTickCount (); } }
END { if ($timeit) { print scalar (localtime);
  printf " - %.3f seconds\n", (Win32::GetTickCount () - $pt0) / 1000; } }

If the script isn't taking excessive time, then you'll need to look
at your server docs for help.  If the script is taking a lot of time,
you could look at some of the debug profiling modules that are available
with Perl (eg: Devel::DProf).
___
Perl-Win32-Web mailing list
Perl-Win32-Web@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs