Does SQL Server cache data?

Hello
I am using SQL Server 2000 SP4
I was going to test my SP in a "clear" environment so I executed
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
But it seems that still something is cached because if I restart server SP
takes longer time than just after clearing query plan caches.
Moreover could you help me with understanding What actually DBCC
DROPCLEANBUFFERS does? What are those clean buffers?
And if something else is really cached could you tell me how can I empty
that cache or see what is inside.
Thanks in advanceDBCC DROPCLEANBUFFERS will remove the buffers (pages) in cache that are clea
n. But you could have
dirty pages in cache (pages which has been modified since read into cache),
and those are not
removed from cache. To make sure you have no dirty pages in cache, execute C
HECKPOINT in the
database first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Korol" <AlexanderKorol@.discussions.microsoft.com> wrote in messag
e
news:AC2F6CE8-3AE8-4513-A789-EC91AEA28819@.microsoft.com...
> Hello
> I am using SQL Server 2000 SP4
> I was going to test my SP in a "clear" environment so I executed
> DBCC FREEPROCCACHE
> DBCC DROPCLEANBUFFERS
> But it seems that still something is cached because if I restart server SP
> takes longer time than just after clearing query plan caches.
> Moreover could you help me with understanding What actually DBCC
> DROPCLEANBUFFERS does? What are those clean buffers?
> And if something else is really cached could you tell me how can I empty
> that cache or see what is inside.
> Thanks in advance|||Thanks a lot

Does Sql 2000 Cluster require DTC?

Hello,
Currently I need to deploy a cluster environment for my client. I've
found many topics discussing about whether Sql 2000 cluster requires
DTC to operate, but still see no final answer for it. Can someone
please help me answer this question?
Thanks,
BN
SQL does not require it, but Exchange does. We have dozens of SQL Clusters
running nicely without MSDTC.
You might need it for your applications to use SQL though, check with your
software vendors.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
<buunguyen@.psv.com.vn> wrote in message
news:1128374943.452421.139090@.f14g2000cwb.googlegr oups.com...
> Hello,
> Currently I need to deploy a cluster environment for my client. I've
> found many topics discussing about whether Sql 2000 cluster requires
> DTC to operate, but still see no final answer for it. Can someone
> please help me answer this question?
> Thanks,
> BN
>
|||Thanks so much for your answer and proof ;-) Rod.
Regards,
Nguyen

Does MS SQL 2000 support multiple processors?

We are in the process of moving our SQL servers to a SAN
environment and decided to upgrade our servers to 4
processors. Therefore, does anyone know if MS SQL 2000
supports multiple processors?Depends on the edition. See BOL: Maximum Capacity Specifications for the
complete OS\Edition matrix. For four processors, you can use any of the
Windows Server OS editions and Standard or Enterprise Edition SQL Server
2000.
From the performance side, SQL does very well with multiple processors.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Cory" <crubicco@.yahoo.com> wrote in message
news:04ae01c3883d$882e63b0$a301280a@.phx.gbl...
> We are in the process of moving our SQL servers to a SAN
> environment and decided to upgrade our servers to 4
> processors. Therefore, does anyone know if MS SQL 2000
> supports multiple processors?

Document for In-Place Upgrade of SQL Server 2000 to 2005

Hi,

We are performing the In-Place upgrade of SQL Server 2000(enterprise) to 2005(enterprise) in a clustered environment.

The issue is that the upgrade does not proceed in case both the machines in the cluster are running.

The error shown is

Product Name : Microsoft SQL Server
Product Version : 9.00.1399.06
Message Source : setup.rll
Message ID : 50000
EvtType : datastore\clustergroupsproperties.cpp@.InvokeSqlSetupDllAction@.ClusterGroupScope.SharedDisks@.0x2

It proceeds (with some errors) only if i stop the cluster service on the other machine. It is an expected behavior?

Does anyone have the documentation for this type of upgrade? Or just the basic steps to be followed.

http://www.sqlservercentral.com/columnists/ssamuel/2987.asp

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

check these links might be helpful

|||

In virtually every case of a cluster upgrade, I always tell my clients to perform a new install and not perform an in-place upgrade. If you have this option, take it. Upgrading in place is possible, but fraught with difficulties.

|||

I would need more information on your configuration and the exact steps you are going through. I wrote the section in the upgrade documentation for upgrading a cluster. I've upgraded both single instance and multi-instance clusters, in place, without any of the issues you are mentioning.

Document for In-Place Upgrade of SQL Server 2000 to 2005

Hi,

We are performing the In-Place upgrade of SQL Server 2000(enterprise) to 2005(enterprise) in a clustered environment.

The issue is that the upgrade does not proceed in case both the machines in the cluster are running.

The error shown is

Product Name : Microsoft SQL Server
Product Version : 9.00.1399.06
Message Source : setup.rll
Message ID : 50000
EvtType : datastore\clustergroupsproperties.cpp@.InvokeSqlSetupDllAction@.ClusterGroupScope.SharedDisks@.0x2

It proceeds (with some errors) only if i stop the cluster service on the other machine. It is an expected behavior?

Does anyone have the documentation for this type of upgrade? Or just the basic steps to be followed.

http://www.sqlservercentral.com/columnists/ssamuel/2987.asp

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

check these links might be helpful

|||

In virtually every case of a cluster upgrade, I always tell my clients to perform a new install and not perform an in-place upgrade. If you have this option, take it. Upgrading in place is possible, but fraught with difficulties.

|||

I would need more information on your configuration and the exact steps you are going through. I wrote the section in the upgrade documentation for upgrading a cluster. I've upgraded both single instance and multi-instance clusters, in place, without any of the issues you are mentioning.