compilcated scnenario question: access + sqlserver + linux + windows

[sugarferret]

hi, in our network we have 2 main servers:
- the sql server
- and the access server
This is the background: the sql server has a windows2003 os and the access has a samba linux os installed. I installed a apache+php webserver in the windows(sql2000) machine and its running queries and pages consulting the local sql server and odbc the access db in the samba linux machine.
This is my question: Its a common or good practice to run the webserver+php+etc in the same machine as the decicated sql2000 server (wich is one of the most important servers in the office)? or should i have one more decitated server running apache and querying the other 2 servers (sql2000 and access)? or i should run the apache+php server in the same machine as samba? if yes: are there a free/Open option for have odbc drivers in the linux server?... or if you have a better idea of how i should handle my machines and servers all comments are welcome. This is too complicated i know.

Well other question... whats the tool you recommend me for analyze the performance and the query time, queries per seccond of the sql server?

Thanks in advance.

Aldo

Live as a tortoise.
and rate my mullet:

http://www.ratemymullet.com/

 

[mrdenny]

It is always recommended that the SQL Server be a standalone machine. SQL is VERY memory and CPU intensive and should always be run by it self.

Microsoft may have some ODBC drivers that can be downloaded. I know that they have JDBC drives that can be used for J2EE.

To find the number of transactions per second you can use either Perfmon or SQL Profiler.

SQL Profiler will give you a list of all the commands, while Perfmon will give you a line graph with the number of transactions (assuming you pick the correct monitor to watch).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sugarferret]

i see, other people said the same about dedicate a machine for sql server... do you know about other odbc driver for linux i am more a php guy than java..

Live as a tortoise.
and rate my mullet:

http://www.ratemymullet.com/