Re: slow work of SQL server

When problem occurs... the sqlserver process have about 1Gb memory.
After restarting it take just 70k memory and working fine...
Seems to me it is kind of memory leak...
Any ideas and how to fight?


"Serdge Petroff" <Super@xxxxxx> wrote in message
news:eJjVc1TNFHA.3560@xxxxxxxxxxxxxxxxxxxxxxx
> Hello!
>
>
>
> Month ago we installed the did cluster for Microsoft server.
>
> It is 3 machines under Windows Server 2003 Enterprise.
>
> 1 and 2 are cluster with MS SQL Server 2000 + SP3
>
> 3 is the storage under WinTarget 1.2 for database only.
>
>
>
> web server is on the machine #4 under Windows 2000.
>
>
>
> so sometimes (once per day) the database starting to work really slow.
>
> (i can connect some pages on the website, but when i'm trying to open
> pages that consist data i'm waiting for a really long time (10 - 12 min)
> or getting timeout error. All query are very simple.
>
>
>
> Usually i'm fixing it by
>
> 1. restarting the MS SQL service and then
>
> 2. bring online cluster group from cluster administrator console.
>
>
>
> What it is can be? Where to search the reason and how to fix?
>
>
>
> Thank you
>
> Serdge
>
>
>
>


.

Relevant Pages

  • Re: Active/Active configuration
    ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
    (microsoft.public.sqlserver.clustering)
  • Re: What is the best backup solution for failover cluster SQL Server
    ... Backing up your SQL database in a clustered environment is not different from a normal server. ... Create a cluster disk share so in the event of a fail over, all nodes will have access to the backup share. ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to configure Network Load Balancing using Two Node?
    ... MVP - Windows Server - Clustering ... > 323431 How To Set Up TCP/IP for Network Load Balancing in Windows Server ... > Guide to Creating and Configuring a Server Cluster under Windows Server ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server Architecture
    ... Mirror WRITE database fails back to primary WRITE database (which is ... now running on the secondary in the cluster). ... the primary server before Windows Clustering does. ... in addition to the database mirroring setup you described. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Node unresponsive, grey screen with no login prompt, still pin
    ... MVP - Windows Server - Clustering ... No events from the hardware agents installed on the box. ... The cluster has been up and running for approx. ...
    (microsoft.public.windows.server.clustering)