fine tune sql cluster

#1

Hi

we are having SQL 2000 for Sharepoint, wss and .net applications in Cluster
(Active / passive mode)

but we feel that it slow, is it anyway to do the fine tunning?

Thanks and Regards
Gopi

#2

Gopi
http://www.microsoft.com/technet/pro...ce-issues.mspx -
---Performance OLTP 2005
http://blogs.msdn.com/euanga/archive...sory-team.aspx -
---Top 10 Best Practices

"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Quote:

Hi

we are having SQL 2000 for Sharepoint, wss and .net applications in
Cluster (Active / passive mode)

but we feel that it slow, is it anyway to do the fine tunning?

Thanks and Regards
Gopi

#3

Thanks Uri

but is there anything for SQL 2000 Cluster?

Regards
Gopi

"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote

Quote:

Gopi
http://www.microsoft.com/technet/pro...ce-issues.mspx -
---Performance OLTP 2005
http://blogs.msdn.com/euanga/archive...sory-team.aspx -
---Top 10 Best Practices

"Gopi" <gopi2it (AT) gmail (DOT) com> wrote in message
news:eiy3zwfRIHA.3388 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Hi

we are having SQL 2000 for Sharepoint, wss and .net applications in
Cluster (Active / passive mode)

but we feel that it slow, is it anyway to do the fine tunning?

Thanks and Regards
Gopi

#4

Gopi
Ah, sorry, I missed that
Cluster configuration has nothing to do with performance of SQL Server. I
have to identify long running queries , queries that consume lots of reads
and deal with it. Run SQL Server Profiler to start investigation.

"Gopi" <gopi2it (AT) gmail (DOT) com> wrote

Quote:

Thanks Uri

but is there anything for SQL 2000 Cluster?

Regards
Gopi

"Uri Dimant" <urid (AT) iscar (DOT) co.il> wrote in message
news:upZzr6fRIHA.4752 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Gopi
http://www.microsoft.com/technet/pro...ce-issues.mspx -
---Performance OLTP 2005
http://blogs.msdn.com/euanga/archive...sory-team.aspx -
---Top 10 Best Practices

"Gopi" <gopi2it (AT) gmail (DOT) com> wrote in message
news:eiy3zwfRIHA.3388 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Hi

we are having SQL 2000 for Sharepoint, wss and .net applications in
Cluster (Active / passive mode)

but we feel that it slow, is it anyway to do the fine tunning?

Thanks and Regards
Gopi

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

fine tune sql cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

fine tune sql cluster - 12-24-2007 , 01:16 AM

Re: fine tune sql cluster - 12-24-2007 , 01:29 AM

Re: fine tune sql cluster - 12-24-2007 , 02:07 AM

Re: fine tune sql cluster - 12-24-2007 , 04:37 AM