Poor performance on SQL 2000 Clustered

Hi all,
i have a 2-node cluster with SQL 2000. I've received many complaints
about the performance. My users tell me that the server is very slow.
The boxes are new (2 cPu Intel Xeon 2'8 GHZ and 4 Gb RAM, ...)
I have used PerfMon to see tipical counters and have seen about 100
page error/sec in memory counter.
In task manager i can see CPU about 4% CPU time and the system has
about 1'5 Gb RAM free.
How can i increase the performance? How can I review my cluster
configuration to get a better situation? I'm new in clustering and i
want to know how can i do it. URLs, all...
Thanks for your help
Clustering has nothing to do with performance of SQL Server. It is a
hardware fail over technology only. You need to do some investigation to see
what the issues are. These should get you started:
http://www.sql-server-performance.co...ce_audit10.asp
Performance Audit
http://www.microsoft.com/technet/pro...perations.mspx
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
Andrew J. Kelly SQL MVP
<salva.gomez@.gmail.com> wrote in message
news:1159529059.960231.275970@.m73g2000cwd.googlegr oups.com...
> Hi all,
> i have a 2-node cluster with SQL 2000. I've received many complaints
> about the performance. My users tell me that the server is very slow.
> The boxes are new (2 cPu Intel Xeon 2'8 GHZ and 4 Gb RAM, ...)
> I have used PerfMon to see tipical counters and have seen about 100
> page error/sec in memory counter.
> In task manager i can see CPU about 4% CPU time and the system has
> about 1'5 Gb RAM free.
> How can i increase the performance? How can I review my cluster
> configuration to get a better situation? I'm new in clustering and i
> want to know how can i do it. URLs, all...
> Thanks for your help
>
sql

Pointing an Analysis Services project at a different database

Hello,

Apologies once again for being new to Analysis Services. I am very grateful for the help that I have received from this forum in the past.

The scenario is that a number of cubes have been built from a number of datasource views that point to a particular database. These datasource views contain a significant number of named queries. The views are structured to resemble star schemas, but the database behind them is an OLTP database, not a data warehouse proper.

This database is the development database for the software product sold by my company. I am trying to rebuild my cubes and dimensions based on another database (a customer database). This has identical structure but different data from the development database. I have tried adding a new data source, pointing at the new database, pointing the data source views at this data source, and refreshing them (they show no changes). I then processed my cubes and dimensions, and deployed the project. The dimension data is not refreshed (e.g. branches still show as the test branches in the development database). Setting the WriteEnabled property of the dimensions to True does not correct the problem.

Does anyone know what to do about this?

Grateful for any help,

Ed Allison

Hi,

I have been doing the same. I use Visual Studio. In my project

Change the data source to point to the specific database.

In your solution select the Project menu, Project properties, Configuration Properties->Deployment->Processing Option = FULL and Deployment Mode = Deploy All. The configuration section should point to the right configuration.

HTH,

|||

That works for me, SunilN. Thanks very much for your help.

Ed Allison

Please help?

Corporate SQL Server is always appear information:
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client..
why ?
bin'an yang
__________________________________________________________________
ChongQingXinHuaBookStore Group HomePage: http://www.cqxhsd.cn/ ICQ#:
217609347 msn: qruntime@.msn.com OICQ:2166286 email: Allen
__________________________________________________________________This is a multi-part message in MIME format.
--=_NextPart_000_0103_01C3737A.90D41B90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
"allen" <qruntime@.hotmail.com> wrote in message =news:OXJxGA2cDHA.1532@.TK2MSFTNGP10.phx.gbl...
> Corporate SQL Server is always appear information:
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client..
> > why ?
> > bin'an yang
> __________________________________________________________________
> ChongQingXinHuaBookStore Group HomePage: http://www.cqxhsd.cn/ ICQ#:
> 217609347 msn: qruntime@.msn.com OICQ:2166286 email: Allen
> __________________________________________________________________
> > This article helps.
http://www.standardio.org/article.aspx?id=3D215
-- JV
___________________________________________________________________
Remotely manage MS SQL db with SQLdirector - =www.ciquery.com/tools/sqldirector/
--=_NextPart_000_0103_01C3737A.90D41B90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
"allen" =wrote in message news:OXJxGA2cDHA.1532@.TK2MSFTNGP10.phx.gbl...
> Corporate SQL Server is always =appear information:> Error: 17805, Severity: 20, State: 3> =Invalid buffer received from client..> > why ?> > bin'an yang> __________________________________________________________________>=; ChongQingXinHuaBookStore Group HomePage: =ICQ#:> 217609347 msn: qruntime@.msn.com =OICQ:2166286 email: Allen> __________________________________________________________________>=; >
This article helps.
http://www.standardio.org/article.aspx?id=3D215">http://www.stand=ardio.org/article.aspx?id=3D215
-- JV___________________________________________________________________=Remotely manage MS SQL db with SQLdirector - http://www.ciquery.com/tools/sqldirector/">www.ciquery.com/tools/=sqldirector/

---

--=_NextPart_000_0103_01C3737A.90D41B90--