Re: SQL Server on same machine as application



Hi Macca,

Affect on performance is defined with how and how much you'll use SQL
Server.
If you'll have a lot of transactions and a lot of reading sql server will
take some resources and of course it can affect performance of application.

--
Danijel Novak



"Macca" <Macca@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:136D3C56-E710-4DF7-86BC-260F8A1076F1@xxxxxxxxxxxxxxxx
> Hi,
>
> I am writing a Real Time monitoring application which will use SQL Server.
> The database will reside on the same PC as the monitoring app.
>
> My question is :- will having SQL Server on the same machine as the
> monitoring app affect the performance of the monitoring app? Will SQL
> server
> use up a lot of the machine resources causing the app to slow down?
>
> I'd appreciate any thoughts,
>
> Thanks In Advance
> Macca


.



Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)

Loading