Web site migration - determining which sites "communicate" with SQL

microsoft.public.sqlserver.server

6 Jul 2009 5:28 PM

Spin

Gurus,

Running Windows 2000 with IIS 5.0 and Windows 2003 with IIS 6.0 and on
another server as a back-end, SQL Server 2005 SP2. On the two IIS servers,
they are serving up about 100 web sites between them. How would I know,
without any documentation, how many of the web sites are communicating with
the SQL Server? Is this something I can obviate from the IIS side or do I
look on the SQL side, or a combination of both?

--
Spin

6 Jul 2009 11:39 PM

bass_player

This would be challenging but I would run a SQL Profiler trace and check the
ApplicationName and the ClientHostName columns to identify the website and
the server name from which the request is coming from

Show quoteHide quote

"Spin" <S***@invalid.com> wrote in message
news:7beqkrF23dal7U1@mid.individual.net...
> Gurus,
>
> Running Windows 2000 with IIS 5.0 and Windows 2003 with IIS 6.0 and on
> another server as a back-end, SQL Server 2005 SP2. On the two IIS
> servers, they are serving up about 100 web sites between them. How would
> I know, without any documentation, how many of the web sites are
> communicating with the SQL Server? Is this something I can obviate from
> the IIS side or do I look on the SQL side, or a combination of both?
>
> --
> Spin

Are all your drivers up to date? click for free checkup

7 Jul 2009 6:06 AM

grbihno

>Gurus,
>
>Running Windows 2000 with IIS 5.0 and Windows 2003 with IIS 6.0 and on
>another server as a back-end, SQL Server 2005 SP2. On the two IIS servers,
>they are serving up about 100 web sites between them. How would I know,
>without any documentation, how many of the web sites are communicating with
>the SQL Server? Is this something I can obviate from the IIS side or do I
>look on the SQL side, or a combination of both?
>
>--
>Spin
>
>
>

for a quick check try exec sp_who or exec sp_who2. You might get some idea.