Starting SQL Server 7 causes hundreds of threads

Dennis

Hello,

I am running SQL Server 7 on a Windows 2000 server, with aprox. 10
databases. The largest database is 1,5 Gb the smallest 10 MB. The
databases are used as databases for various websites.

My problem is that (since a few days), when I start the MS SQL Server
7 service, the process (sqlservr.exe) is directly increasing fast to
approx. 500+ (513 or 517) threads. With about 60MB of used memory. The
strange thing is that it always goes to exactly 517 or 513. My maximum
number of configured threads is 500. So that is also quite strange...

The processor activity is not different from normal (in other words,
the threads are not causing higher processor activity).

One strange thing also is that the server is receiving a BIG bunch of
the data (42 Megabit burst) about every 2 hours. It looks like a hack?
I've installed ALL security patches and all 1432 to 1434 ports are
blocked.

Does anybody have an idea where this could be about?

Is there a possibility to track down who/what is using/causing each
individual thread? In SQL server manager the number of threads are a
lot lower, as I could see there are about 10-15 threads...

Thanks in advance!!

Regards,

Dennis.

Jul 20 '05 #1

Subscribe Post Reply

1445

Similar topics

PHP sessions starting to fail

by: jamie howard | last post by:

Hello there - we have a fairly busy server and we just started to have problems with PHP sessions failing. We've never had this problem before and to be honist, out server traffic is lower than it...

PHP

High volume websites using Python web server software?

by: Irmen de Jong | last post by:

Hi, Things like Twisted, medusa, etc.... that claim to be able to support hundreds of concurrent connections because of the async I/O framework they're based on.... can someone give a few...

Python

Starting server problems

by: zeedan | last post by:

Hi, I appologise if I'm not posting this to the correct group, but I'm having problems starting MySQL server. I need it in order to post a websurvey for a research project I'm doing for a college...

MySQL Database

windows service not starting threads on newly deployed server

by: karl | last post by:

I have a windows service that kicks off a 'monitor' thread which in turn kicks off 4 additional threads. These 4 threads basically are listen on a designated socket and report back any errors...

C# / C Sharp

Save data to server without postback?

by: Mike Szanto | last post by:

I have an intranet application where some pages display large tables of editable data. I've designed the page to operate like Microsoft Access where the user can move from cell to cell and as they...

ASP.NET

Calling a Web Service hosted on a Web Logic server from a C# SOAP client

by: Nate | last post by:

We are attempting to make a request to a web service (we will refer to it as XXXServices) hosted on a Web Logic server from a C# SOAP client. The server responds with a 401 Unauthorized error...

.NET Framework

IIS 6.0, ASP pages, HTTP Error 500.13 - Server error

by: rezapasha | last post by:

Hello, we have a website in ASP , the pages connected to .mdb access database by ODBC there is a big traffic on this site, so after 9-10 hour the server show this error to visitors : HTTP Error...

ASP / Active Server Pages

multithreaded tcp/ip server large page file

by: cj | last post by:

I have a 2005 TCP/IP server that creates a new thread to handle each incoming TCP/IP request. Once the request has been answered by the thread the TCP/IP socket is disconnected and the sub/thread...

Visual Basic .NET

Connecting using socket class to server: Scalability/Performance

by: Bruce | last post by:

Hello I am building a C# app that creates anywhere from 10 to 100 connections to a specified server and sends 1000s of TCP requests and processes the responses. (it is a stress tool) I planned...

C# / C Sharp

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing