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
