Has any every had a problem with the probe login / SQL Perfmon processes not clearing out and maxing out users
connections? Microsoft has recommended I rename the sqlctr60.dll to sqlctr60.old. This causes my application
event log to fill up after about 10 min because it is trying to make a connection. They say this is a problem
running on a compaq server. I am running NT 4.0 sp 4, SQL6.5 sp5a. Any ideas?
Thanks
Tammy Maxfield
I work for a large company that has an OLTP SQL Server Cluster that I am solely responsible for.
This environment has about 150 Databases serving different divisions within the organization.
About 9 months ago, this environment was brought online using a Compaq Storageworks Enterprise Virtual Array. It is made up of 72 Disks in a RAID-5 Configuration for Random Read/Write Data and 18 Disks in a RAID-10 Configuration for Sequential activity only (i.e. - Logs).
I have been experiencing a SQL Server/Disk IO problem for 10 weeks now and still there is no resolution from HP/Compaq on the issue.
Here is a description of the problem:
Those familiar with Windows 2000 Internals know that when Disk IO's occur, they are handed off to the Disk Controller(s) to be serviced. What is happening is that whenever Writes occur to the Data Segment, and are being handed off to the HBA's(Host Bus Adapters), the outstanding write queues go through the roof! I have experienced Oustanding Write Queue lengths of more than 170/sec sustained at times.
This is also represented by the disks being utilized 100% according to Performance Monitor, but not via the SAN Monitoring tools.
The facts we know about our issue are:
1. The Fabric Switch Ports are not over-utilized
2. Server-side resources such as memory, cpu, network, etc. are not breaking a sweat.
3. The Disks on the SAN are serving other customers without any issues in regards to speed.
4. Fibre has been replaced for both HBA's in the server(s).
5. The latest Firmware is in affect on the Compaq EVA
6. Any locally attached disks on the same SQL Server(s) do not reproduce the problem only SAN Disks
7. This problem is reproducable on any SQL Server that we present SAN attached storage to.
We have gone throught just about every configuration change from the HBA to the SAN Switches themselves to try and correct the issue, but none have proven to work. I have spun my wheels trying to convince HP/Compaq that the problem is real and that users are being impacted by it as perceived "Slow Response Times" on their end.
Any insight from experienced SQL Server DBA's/System Engineers as to what could be causing the bottlenecks on the SAN would be greatly appreciated.
Hi,
Does anybody know if SQL7 server in running in 6.5 compat mode allow
row-level locking ?????
Thanks
Mahesh
The database devices was showing a negative number size, so i expanded the database which has cleared this problem, however, now when users try to input a form(each form is allocated a unique reference number) for this database the reference number has reset and is starting off at 1 instead of following on from the previous form number before this problem occurred.
View 1 Replies View RelatedHello
when I installed SQL6.5 on a server with Win2000 I received a message saying that SQL6.5 could "not be installed on this version of Windows."
Can someone please tell me what the story is here.
Regards
De Waal
I created a DTS task to transfer data from a SQL7.0 table to a SQL6.5 table. This trasfer is really slow.
The transfer the other way is amazingly fast.
Any ideas ??
Thank you in advance.
Can my Access 97 db's connect to both a SQL 6.5 and 7.0 without a problem.
has anybody tried this?
Hi all :
Does the upgrade wizard in 7.0 help me upgrade ALL the database objects in SQL 6.5 (including stored procedures, triggers) to 7.0? Has anyone encountered any problems?
Rnathan
Hello All,
Does anyone know if stored functions can be written for sql similar to stored procedures? And if theey
can, what language?
Thanks
I am attempting to connect to my SQL 6.5 Server through IPX. We currently have a WindowsNT network setup with a Novell Server v3.12 running as a file and login server. When I setup IPX/SPX as a network protocal to use, and then set it in the client configuration , I get a specific error.
"Cannot Connect To SQL Server : Login Failed"
Maybe I am missing a step in my setup somewhere. Has anyone encountered this with using IPX? It connects perfectly using named pipes, but only see this error when I try to use IPX. All help is appreciated. Thank You.
Michael Mroz
Libera, Inc.
Jamestown, NY
Can SQL6.5 and SQL7.0 live on the same NT4.0 server?
View 2 Replies View RelatedI just started as a junior dba and I'm monitoring a SQL6.5 database and I need some help with a certain issue, as to what I should be looking for.
Recently, the program we use to retrieve data from the database has been freezing up on everyone. What I did was just kill some user's processes from Enterprise Manager which seems to work. But we never had this problem before. And since everyone has been closing their programs prematurely, the error log contains many errors like this:
Error: 1608, Severity: 21, State: 2
A network error was encountered while sending data to the front end.
Error: 17824, Severity: 10, State: 0
Unable to write to ListenOn Connection pipesqlquery.....
We have a dedicated server for this database and there's about 20 requests to the database at any given time.
If anybody can tell me what to do, I would greatly appreciate it. Thank you.
Does anyone know of any issues that need to be considered when installing NT sp4.
Since doing so we are getting unexpected database behaviour
thanks in advance
Can you restore a SQL6.5 backup to a Sql2000sp3 ?
View 7 Replies View RelatedHi all
I would like to know - we are currently running SQL6.0 on NT4 servers. We have 2 x 3rd party programs that runs on the servers, making use of the databases. We don't forsee any changes in the near future.
Question: will it be wise to upgrade to SQL7 anyways, or can we keep the status quo as is ???
Rgds
De Waal
I installed SQL 7 on a new computer and imported DB from another SQL 6.5.
Tables were imported but index and SPs were not.
I had to script those objects and run it on SQL 7.
Any shortcut to import all objects directly?
Again I was importing not upgrading.
Hi all,
I receive the following error message every time I run this script:
INSERT INTO archive_temp (mrn, folder, name)
SELECT a.mrn, a.encounter, a.name
FROM his..active a, cabinet..cabinet c
WHERE imnet like 'images3%'
ORDER BY a.mrn, a.encounter
GO
After 10 minutes I get this ERROR MESSG: Can't allocate space for object
'-1443' in database 'tempdb' b/c the 'system' segment is full. If you
ran out of space in Syslogs, dump the transaction log. Otherwise use
'Alter database" or sp_extendsegment to increase the size of segment.
So far, i've updated the tempdb log segment from 100 mb to 500 mb
shared with data. I don't understand why I am still getting this error.
When I look at Performance Monitor, the log for tempdb is not peaked at
all!
can anyone help?
Thanks
Chris
I need to transfer databases from one server to the other.
(They are identical sort order/char set/...) but as I did
all passwords were set to NULL....How can I use the
generated scripts to transfer without losing them ?
(Have about 300 users...) Thank you for your help !!
I Completely new to SQL, can anyone give me a URL to find this information.?
Thanks
Can it be done?
View 2 Replies View RelatedHi!
I just have one short question.
Is there a way to change the sort order in SQL 6.5 short of re-installing
the whole database?
If there is, how do I go about it?
TIA
Johan
i've a sql server 6 and sql server 7 located in 2 different domain.
how could i migrate the database from my sql 6 to sql 7?
I`m planning on installing sql7 beta on my desktop. Currently I have sql6.5 client tools installed on my desktop for performing DBA tasks against our test and prod. sql6.5 servers. Does anyone know if installing sql7 will conflict with my sql6.5 client tools or cause any other problems?
Thanks
In SQL 6.5, you could Transfer (through a menu item in Enterprise Mgr) all or parts of a database to another server. It was the perfect 'copy' mechanism. What happened to it?
Thanks,
Judith
Hi
Is it possible to add jobs into the SQL schedule by means of a SQL script. We have 1000 remote servers to update and don't really want to do it manually.
Any help appreciated.
Ian
I have heard that there are potential problems if you put service pack for NT on your server, in that it conflicts with SQL 6.5. Does anyone know of
any such problems with either running 6.5 under these conditions or installing 6.5 if the service pack is already on the server.
Thanks
hi
I want to ask the method to calculate the memory in the configuration in SQL6.5.
If I have 256MB memory installed in the server, how many memory needed in the configuration of SQL6.5.
I'm thinking to upgrade SQL6.5 DB to SQL 2000 but do not know
all client access with SQL 6.5 utility will work ???
(The application is a vendor canned package using SQL 7.0 DB
but client can access with 6.5 ---Not using ODBC)
Any experts can help ?
Thank you in advance !!
Lewis
I am having the following error when running the SQL upgrade wizard trying to upgrade SQL 6.5 to SQL 2000. Does anyone here know what is the problem ?
Version Switch has aborted because you do not have "Full Control" permission to one of the HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServ* registry keys. Please use regedit32.exe to correct this problem and try again.
I have already checked the registry and I do have full control permission on HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServ*. Please help.
I want create trigger in sql7 insert or update in data base sql6.5
Quiero crear un trigger en sql7 que haga un Insert o update en una base de datos de sql6.5, se puede y como?
Hi:
After I am install SQL7.0 clent tools in my WINDOWS95,
The SQL7.0 database can access very well,
but I am access SQL6.5 database object(tables) then the select data is bad,
why ? help me please.
I was wondering if the only way to import MSaccess files into sql6.5 is to dump the MSaccess file into a text file and then recreate the structure in SQL6.5 and then use the bcp command to copy the data into the new structure.
Is there an easier way?
thanks in advance.
Rich
LoPingKill
loping@inlink.com
Hello Reporting Services 2005 users or Reporting Services Team,
I have done everything to get pass this error but no luck.
My setup is :- WIndows 2003 Standared Edition SP1
Sql Server :-
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Reporting Services starting SKU: Standard.
From the Reporting Services Configuration Manager:
I can see all other things configured except Encryption Keys(blue sign)
Initialization(Grey sign) and Execution Acct(Yellow sign)
My windows Service Identity is using :
NT AuthorityNetworkService
Builtin Acct :NetworkService
Web Service Identity :-
ASP.NET Service Acct :- NT AuthorityNetworkService
DataBase Setup :- Credentials Type :- Service Credentials
I have also done everything from here thanks to Göran
http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861
and
http://forum.k2workflow.com/viewtopic.php?t=619&
If you guys any solution for this please let me know.
I was wondering could this be a scale-out deployment issue ?
I also get the error when setting up the DataBase Setup :
Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys
My Error log file is below:-
w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.