RE: slow work of SQL server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

Check that you don't have any blocking in the DB. run sp_who2 when the
problem occurs.

Are you using a non fiber SCSI or non iSCSI storage device? Is server 3
storage? If so, that is a NAS and may not be supported.

Regards
Mike

"Serdge Petroff" wrote:

> 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: 2 node Active/Active with 2 separate storage servers all in 1.
    ... We run combinations of Multiple SANs and / or multiple SAN Networks. ... Mike Epprecht, Microsoft SQL Server MVP ... Is that multiple SAN networks or Storage Servers? ... >> and this SAN will be your single point of failure for the cluster. ...
    (microsoft.public.sqlserver.clustering)
  • 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: 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: [PHP] Re: how to display images stored in DB
    ... there is issue of going to the database and going to the ... database for meta data and server and file location. ... But easy to solve by breaking down meta data and storage parts. ...
    (php.general)