hi pf usage

Hi all,
I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
I have enabled AWE & PAE. The performance monitor shows a constant usage of
7.55GB of on the pagefile. Is this normal'
TIA!Yo have SP4. Did you apply KB 899761?
http://support.microsoft.com/kb/899761/
FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4
Use Performance Monitor to look into
SQLServer:Memory Manager - Total Server Memory (KB)
to verify SQL Server is using all the memory you are giving to it
Ben Nevarez, MCDBA, OCP
Database Administrator
"param@.community.nospam" wrote:
> Hi all,
> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
> I have enabled AWE & PAE. The performance monitor shows a constant usage of
> 7.55GB of on the pagefile. Is this normal'
> TIA!
>
>|||Yes, I have SP4 and have applied that hotfix. Perfmon shows 7534008 KB. What
could be up?
Thanks
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>|||OK, here is the weird part. I checked my 2nd node of the cluster and its PF
usage is only at about 400MB. What is weird is that I am running an
Active-Active mixed cluster. Server1 is running SQL2000 SP4 and has the
issue with high memory usage. Server2 is running SQL2005 SP1 and seems fine
on memory usage. Both the servers are identical machines.
TIA!
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>

HF for SQL2000 on Windows 2003 Cluster

We just build our first 2 nodes cluster on Windows 2003 / SQL2000 SP3a + HF
818.
Does anybody knows if there is any other HF need to be applied on Windows or
SQL running cluster services before we go live?
Thanks
Ayad
That depends on whether you are experiencing any problems that are covered
by a later hotfix. I generally don't apply a hotfix unless I need the
specific functionality it covers. Service Packs are a different issue.
Those go in as soon as they are carefully tested.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:%23MoDxbWsEHA.2800@.tk2msftngp13.phx.gbl...
> We just build our first 2 nodes cluster on Windows 2003 / SQL2000 SP3a +
HF
> 818.
> Does anybody knows if there is any other HF need to be applied on Windows
or
> SQL running cluster services before we go live?
> Thanks
> Ayad
>

Heterogeneous queries

Hi Guys,

I have one stored procedure on SQL 6.5 and retrieving data from SQL
2000. I have defined a linked server on SQL 6.5. But
I am getting following error:-

"Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options
to be set for the connection. This ensures consistent query semantics.
Enable these options and then reissue your query."

I dropped and re-create the stored procedure after adding the SET
ANSI_NULLS & SET ANSI_WARNINGS ON in stored procedure but still getting
this error. I have created this sp on ISQL/W not in Enterprise Manager.

Can anyone please let me know, how to fix this problem.

Thanks
AdnanAdnan (adnanjamil58@.yahoo.ca) writes:
> I have one stored procedure on SQL 6.5 and retrieving data from SQL
> 2000. I have defined a linked server on SQL 6.5. But
> I am getting following error:-
> "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options
> to be set for the connection. This ensures consistent query semantics.
> Enable these options and then reissue your query."
> I dropped and re-create the stored procedure after adding the SET
> ANSI_NULLS & SET ANSI_WARNINGS ON in stored procedure but still getting
> this error. I have created this sp on ISQL/W not in Enterprise Manager.
> Can anyone please let me know, how to fix this problem.

The setting of ANSI_NULLS is saved with the procedure, why it does
not help setting ANSI_NULLS within the procedure.

ANSI_NULLS is on by default with most interfaces - but not if you use
DB-Library, and the 6.5 tools uses DB-Library. If you insist on using
6.5 tools, be sure to always include this:

SET ANSI_DEFAULTS ON
SET IMPLICIT_TRANSACTIONS OFF
SET CURSOR_CLOSE_ON_COMMIT OFF

then you get the same settings as in the SQL 2000 tools.

Certainly far more easier is to use Query Analyzer. (You mentioned
Enterprise Manager. If you mean the 6.5 tool, it has the same issue
as ISQL/W. It you mean EM 2000, this is a poor tool for maintaining
stored procedures.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog (esquel@.sommarskog.se) writes:
> The setting of ANSI_NULLS is saved with the procedure, why it does
> not help setting ANSI_NULLS within the procedure.

A clarification: the setting of ANSI_NULLS that applies for a stored
procedure, is the setting that was in effect when you created the procedure.
The rest below applies as before:

> ANSI_NULLS is on by default with most interfaces - but not if you use
> DB-Library, and the 6.5 tools uses DB-Library. If you insist on using
> 6.5 tools, be sure to always include this:
> SET ANSI_DEFAULTS ON
> SET IMPLICIT_TRANSACTIONS OFF
> SET CURSOR_CLOSE_ON_COMMIT OFF
> then you get the same settings as in the SQL 2000 tools.
> Certainly far more easier is to use Query Analyzer. (You mentioned
> Enterprise Manager. If you mean the 6.5 tool, it has the same issue
> as ISQL/W. It you mean EM 2000, this is a poor tool for maintaining
> stored procedures.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp