Cluster SQL 2000 errorlog problem

We've recently installed a couple of Windows Server 2003 Ent Ed servers with
SQL 2000 Ent Ed and one of the active/active nodes continually gives the
error below in the Application Event log.
The NT user which was used to install the server and owns the directories
and files below has full rights so this should not be an issue.
I've checked MSDN, etc. but nothing which seems to help.
Thanks.
Ron
17050 :
initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot find
the path specified.).
Ron,
Is drive D local to the server or on the cluster's shared drives? The error
message could be implying that the node in question was installed with the
data files on a local drive.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> We've recently installed a couple of Windows Server 2003 Ent Ed servers
with
> SQL 2000 Ent Ed and one of the active/active nodes continually gives the
> error below in the Application Event log.
> The NT user which was used to install the server and owns the directories
> and files below has full rights so this should not be an issue.
> I've checked MSDN, etc. but nothing which seems to help.
> Thanks.
> Ron
> --
> 17050 :
> initerrlog: Could not open error log file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\log\ERRORLOG'. Operating system error = 3(The system cannot
find
> the path specified.).
> --
|||BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
that contains a lot of detail not available elsewhere:
http://support.microsoft.com/default...lurb020703.asp
Ron
Ron Talmage
SQL Server MVP
"Ron Talmage" <rtalmage@.prospice.com> wrote in message
news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> Ron,
> Is drive D local to the server or on the cluster's shared drives? The
error[vbcol=seagreen]
> message could be implying that the node in question was installed with the
> data files on a local drive.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:7BABBA49-964A-4422-ACB8-B559661A5F05@.microsoft.com...
> with
directories[vbcol=seagreen]
SQL
> find
>
|||Ron,
I'll review the webcast...thanks!
SQL Server is installed on the C: drive, the data files are installed on D:
which is a SAN drive share.
I've rebooted both nodes and only started node1...with node2 offline, there
errors are not appearing in the event logs...? Seems odd as it's node1 which
is logging the errors...any other ideas?
Thanks.
Ron
"Ron Talmage" wrote:

> BTW, there's a webcast on troubleshooting a SQL Server 2000 cluster install
> that contains a lot of detail not available elsewhere:
> http://support.microsoft.com/default...lurb020703.asp
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ron Talmage" <rtalmage@.prospice.com> wrote in message
> news:%23c46wJI%23EHA.3368@.TK2MSFTNGP15.phx.gbl...
> error
> directories
> SQL
>
>

Clients connect via Named Pipes even though its disabled

We've got SQL 2000 clients (standard install, no sp) who are connecting
to our SQL 2000 Servers with Named Pipes even though we've disabled
named pipes in the client network utility. They should be connecting
via tcp/ip. Any ideas on what could be causing this?
Hi Gary,
How are you determining that the client is connecting using named pipes? Is
there a chance that your connection string is prefixed with "np:"? If so,
this will override any client network settings. Otherwise, this is probably
the result of the last connection being cached. One way around this would
be to force the connection to use tcp/ip and this will overwrite the cache.
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary.noon@.tradeweb.com> wrote in message
news:1118352084.179815.156620@.g14g2000cwa.googlegr oups.com...
> We've got SQL 2000 clients (standard install, no sp) who are connecting
> to our SQL 2000 Servers with Named Pipes even though we've disabled
> named pipes in the client network utility. They should be connecting
> via tcp/ip. Any ideas on what could be causing this?
>

client/server performance problems

We have 1000 users on a client/server CRM application that we've written in
house. Recently we started experiencing performance problems at the top of
each hour, it lasts for about 30 seconds. I have run several traces using
these events:
lock: acquired,
lock: deadlock,
rpc: completed,
sql: stmtcompleted
Each trace runs from 10 till the hour until 10 after the hour. I've dumped
them out to tables so I could query them for the top 200 records by cpu,
duration, reads and writes. I then query them by each minute of starttime to
find the worst queries. I have fixed a lot of bad queries over the past
couple of weeks but still users are complaining. We are runnings Sql Server
2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for the
server but our I'm told it has a lot of cpu and at I think 8GB of memory. I
am not a dba, I am a developer but I cant understand why I'm not solving the
problem. The queries that I've fixed are running much faster, but still the
problem persists.
Am I not using the right events in SQL Profiler? Is it possible that we're
really having some sort of network issue at that time? I would use Perfmon
but that doesnt tell me much.
Any help is appreciated,
Doug
My guess is you have a scheduled job that runs on the hour each hour. It
could also be related to checkpoints but they rarely follow such an exact
cycle. You can see these with the SQL counter CHeckpoin Pages per second.
You should monitor for CPU, Disks etc as well. See if these help:
http://www.microsoft.com/sql/techinf...perftuning.asp
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=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Doug Stiers" <doug@.nospam.com> wrote in message
news:%23t7lrXYCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> We have 1000 users on a client/server CRM application that we've written
> in
> house. Recently we started experiencing performance problems at the top of
> each hour, it lasts for about 30 seconds. I have run several traces using
> these events:
> lock: acquired,
> lock: deadlock,
> rpc: completed,
> sql: stmtcompleted
> Each trace runs from 10 till the hour until 10 after the hour. I've dumped
> them out to tables so I could query them for the top 200 records by cpu,
> duration, reads and writes. I then query them by each minute of starttime
> to
> find the worst queries. I have fixed a lot of bad queries over the past
> couple of weeks but still users are complaining. We are runnings Sql
> Server
> 2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for
> the
> server but our I'm told it has a lot of cpu and at I think 8GB of memory.
> I
> am not a dba, I am a developer but I cant understand why I'm not solving
> the
> problem. The queries that I've fixed are running much faster, but still
> the
> problem persists.
> Am I not using the right events in SQL Profiler? Is it possible that we're
> really having some sort of network issue at that time? I would use Perfmon
> but that doesnt tell me much.
> Any help is appreciated,
> Doug
>