|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > sql server 7 very slow with many users - kind of lengthy but i need an opinion
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server 7 very slow with many users - kind of lengthy but i need an opinion
|
|
|
| first of all i'm not an sql expert at no means and don't pretend to be
but the application developer keeps saying that my netwrok is at fault
here is my configuration
compaq ml530 server
2 pentium III 800 mhz xeon processors
4 gb memory
30 gig scsci raid drive array
the only thing runing on this server is sql 7
with mcafee netshield
network consists of workstations all with 100 mb nic cards, and cisco 100 mb
switches
with a couple of 10mb hubs for small groups
we are using sql server 7 in a medical application, it is used for
appointment scheduling
accounting - billing, posting charges, posting payments
demographic patient information
insurance information
provider (doctor iinformation - insurance company id codes etc )
60,000 pateint records
and in all about 1.7 million total records
the application developer will not let us delete or archive and old or
duplicate information
the client side is written in delphi I was told
we constantly have about 80 -90 users connected and workling on the database
it's so slow it's painfull
once my cisco switches all went down at the same time and one group using
the 10mb
hubs called me and asked what i did, the system was faster, my only answer
and
summation was less users on line
we now have 3 people who come in on the weekend when nobody is on the system
and
they say the system flies
also the server task manager show me that SQLSERVER.EXE is using close to
100% of the
processors most of the time and memory used is about 1.8gb
i got and sql monitor to look at what was going on and it has a connection
counter and that show
over 800 user connections
when i look in computer managment console and shared files some people have
17 to 25 files open
i had an sql programmer look at my sql server and she said they are doing
things with procedures
that can be done better - what i don't know but i need help with this
problem
anyone know what can be done ?
thanks in advance
--
Rich
| |
| Dan Guzman 2002-11-01, 10:23 pm |
| I suggest you identify the cause of the high SQL Server CPU utilization.
This could be due to a number of factors, including poorly designed
databases, inadequate indexing, bad stored procedure coding, poor
application architecture, etc.
Start by using SQL Profiler to identify the problem SQL queries. See
<http://support.microsoft.com/defaul...;EN-US;Q224587&> for
tips on how to do this.
--
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"rich" <rjs211@optonline.net> wrote in message
news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> first of all i'm not an sql expert at no means and don't pretend to be
> but the application developer keeps saying that my netwrok is at fault
> here is my configuration
> compaq ml530 server
> 2 pentium III 800 mhz xeon processors
> 4 gb memory
> 30 gig scsci raid drive array
> the only thing runing on this server is sql 7
> with mcafee netshield
> network consists of workstations all with 100 mb nic cards, and cisco
100 mb
> switches
> with a couple of 10mb hubs for small groups
>
> we are using sql server 7 in a medical application, it is used for
> appointment scheduling
> accounting - billing, posting charges, posting payments
> demographic patient information
> insurance information
> provider (doctor iinformation - insurance company id codes etc )
> 60,000 pateint records
> and in all about 1.7 million total records
> the application developer will not let us delete or archive and old or
> duplicate information
> the client side is written in delphi I was told
> we constantly have about 80 -90 users connected and workling on the
database
> it's so slow it's painfull
> once my cisco switches all went down at the same time and one group
using
> the 10mb
> hubs called me and asked what i did, the system was faster, my only
answer
> and
> summation was less users on line
> we now have 3 people who come in on the weekend when nobody is on the
system
> and
> they say the system flies
> also the server task manager show me that SQLSERVER.EXE is using close
to
> 100% of the
> processors most of the time and memory used is about 1.8gb
> i got and sql monitor to look at what was going on and it has a
connection
> counter and that show
> over 800 user connections
> when i look in computer managment console and shared files some people
have
> 17 to 25 files open
> i had an sql programmer look at my sql server and she said they are
doing
> things with procedures
> that can be done better - what i don't know but i need help with this
> problem
> anyone know what can be done ?
>
> thanks in advance
> --
> Rich
>
>
| |
| BP Margolin 2002-11-01, 11:23 pm |
| Rich,
In addition to the information posted by Dan:
Since you have a McAfee Netshield on your server that you might be
interested in the following:
http://support.microsoft.com/defaul...b;en-us;Q309422
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"rich" <rjs211@optonline.net> wrote in message
news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> first of all i'm not an sql expert at no means and don't pretend to be
> but the application developer keeps saying that my netwrok is at fault
> here is my configuration
> compaq ml530 server
> 2 pentium III 800 mhz xeon processors
> 4 gb memory
> 30 gig scsci raid drive array
> the only thing runing on this server is sql 7
> with mcafee netshield
> network consists of workstations all with 100 mb nic cards, and cisco 100
mb
> switches
> with a couple of 10mb hubs for small groups
>
> we are using sql server 7 in a medical application, it is used for
> appointment scheduling
> accounting - billing, posting charges, posting payments
> demographic patient information
> insurance information
> provider (doctor iinformation - insurance company id codes etc )
> 60,000 pateint records
> and in all about 1.7 million total records
> the application developer will not let us delete or archive and old or
> duplicate information
> the client side is written in delphi I was told
> we constantly have about 80 -90 users connected and workling on the
database
> it's so slow it's painfull
> once my cisco switches all went down at the same time and one group using
> the 10mb
> hubs called me and asked what i did, the system was faster, my only answer
> and
> summation was less users on line
> we now have 3 people who come in on the weekend when nobody is on the
system
> and
> they say the system flies
> also the server task manager show me that SQLSERVER.EXE is using close to
> 100% of the
> processors most of the time and memory used is about 1.8gb
> i got and sql monitor to look at what was going on and it has a connection
> counter and that show
> over 800 user connections
> when i look in computer managment console and shared files some people
have
> 17 to 25 files open
> i had an sql programmer look at my sql server and she said they are doing
> things with procedures
> that can be done better - what i don't know but i need help with this
> problem
> anyone know what can be done ?
>
> thanks in advance
> --
> Rich
>
>
| |
|
| thanks for all the info so far, but can someone tell me if it is normal to
have 800 plus connections (with 90 users) as i stated before. i read
somewhere that every user conection is allocated about 40,000 bytes of
memory and if these should be closed when not in use
thanks again everyone
--
Rich
"rich" <rjs211@optonline.net> wrote in message
news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> first of all i'm not an sql expert at no means and don't pretend to be
> but the application developer keeps saying that my netwrok is at fault
> here is my configuration
> compaq ml530 server
> 2 pentium III 800 mhz xeon processors
> 4 gb memory
> 30 gig scsci raid drive array
> the only thing runing on this server is sql 7
> with mcafee netshield
> network consists of workstations all with 100 mb nic cards, and cisco 100
mb
> switches
> with a couple of 10mb hubs for small groups
>
> we are using sql server 7 in a medical application, it is used for
> appointment scheduling
> accounting - billing, posting charges, posting payments
> demographic patient information
> insurance information
> provider (doctor iinformation - insurance company id codes etc )
> 60,000 pateint records
> and in all about 1.7 million total records
> the application developer will not let us delete or archive and old or
> duplicate information
> the client side is written in delphi I was told
> we constantly have about 80 -90 users connected and workling on the
database
> it's so slow it's painfull
> once my cisco switches all went down at the same time and one group using
> the 10mb
> hubs called me and asked what i did, the system was faster, my only answer
> and
> summation was less users on line
> we now have 3 people who come in on the weekend when nobody is on the
system
> and
> they say the system flies
> also the server task manager show me that SQLSERVER.EXE is using close to
> 100% of the
> processors most of the time and memory used is about 1.8gb
> i got and sql monitor to look at what was going on and it has a connection
> counter and that show
> over 800 user connections
> when i look in computer managment console and shared files some people
have
> 17 to 25 files open
> i had an sql programmer look at my sql server and she said they are doing
> things with procedures
> that can be done better - what i don't know but i need help with this
> problem
> anyone know what can be done ?
>
> thanks in advance
> --
> Rich
>
>
| |
| Andrew J. Kelly 2002-11-03, 9:23 am |
| Probably not normal but not imposable. I have seen very poorly written
front ends that open way more connections than need be. Chances of your 90
users really needing 800 open connections is slim. I would pick one user
and study all the open connections to see what they are doing. More than
likely they are opening them and not closing them when done.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"rich" <rjs211@optonline.net> wrote in message
news:33Xw9.29600$S44.12547@news4.srv.hcvlny.cv.net...
> thanks for all the info so far, but can someone tell me if it is normal to
> have 800 plus connections (with 90 users) as i stated before. i read
> somewhere that every user conection is allocated about 40,000 bytes of
> memory and if these should be closed when not in use
>
> thanks again everyone
> --
> Rich
>
> "rich" <rjs211@optonline.net> wrote in message
> news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> > first of all i'm not an sql expert at no means and don't pretend to be
> > but the application developer keeps saying that my netwrok is at fault
> > here is my configuration
> > compaq ml530 server
> > 2 pentium III 800 mhz xeon processors
> > 4 gb memory
> > 30 gig scsci raid drive array
> > the only thing runing on this server is sql 7
> > with mcafee netshield
> > network consists of workstations all with 100 mb nic cards, and cisco
100
> mb
> > switches
> > with a couple of 10mb hubs for small groups
> >
> > we are using sql server 7 in a medical application, it is used for
> > appointment scheduling
> > accounting - billing, posting charges, posting payments
> > demographic patient information
> > insurance information
> > provider (doctor iinformation - insurance company id codes etc )
> > 60,000 pateint records
> > and in all about 1.7 million total records
> > the application developer will not let us delete or archive and old or
> > duplicate information
> > the client side is written in delphi I was told
> > we constantly have about 80 -90 users connected and workling on the
> database
> > it's so slow it's painfull
> > once my cisco switches all went down at the same time and one group
using
> > the 10mb
> > hubs called me and asked what i did, the system was faster, my only
answer
> > and
> > summation was less users on line
> > we now have 3 people who come in on the weekend when nobody is on the
> system
> > and
> > they say the system flies
> > also the server task manager show me that SQLSERVER.EXE is using close
to
> > 100% of the
> > processors most of the time and memory used is about 1.8gb
> > i got and sql monitor to look at what was going on and it has a
connection
> > counter and that show
> > over 800 user connections
> > when i look in computer managment console and shared files some people
> have
> > 17 to 25 files open
> > i had an sql programmer look at my sql server and she said they are
doing
> > things with procedures
> > that can be done better - what i don't know but i need help with this
> > problem
> > anyone know what can be done ?
> >
> > thanks in advance
> > --
> > Rich
> >
> >
>
>
| |
|
| Xref: tkmsftngp01 microsoft.public.sqlserver.server:240770
hi andrew
thanks for your response
i'm with you that 90 users don't need 800 connections open but the frontend
is written so that all you can do
is open files and have no option to close a connection (maybe i'm not saying
this correctly) but if a user
goes into the patient file to make a new appointment and the into the
appointment file to complete the appoinmtment i can understand both files
staying open because those users are always using those files
it's the user that opens other files like accounting, insurance, and many
others but these files never get closed
i have looking at open files in the management console and some users have
20 + files open for days at a time
(they never closed the application, but thats another story)
also every night i have the i run a task to shut doen sql server and restart
it, but these connections still exsist
i have to make everybody log off the application sometimes and shutdown the
server and restart to free u pall these connections
is there anything i can have done to the sql server database, as the
frontend developer denies anything is wrong with his application or database
and keeps blaming it on the hardware. (what else is new) like i said before
i had an sql server programmer (thru a friend who knows her ) look at the
database and she said she saw problems that could be fixed, i would like a
second opinion but find it hard to find sql programmers. do you know of any
good sql programmers in the new york city area and if so give me a way to
get in contact with them.
thanks very much for you time
rich schofield
--
Rich
"Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
news:OQB7Pf0gCHA.1760@tkmsftngp12...
> Probably not normal but not imposable. I have seen very poorly written
> front ends that open way more connections than need be. Chances of your
90
> users really needing 800 open connections is slim. I would pick one user
> and study all the open connections to see what they are doing. More than
> likely they are opening them and not closing them when done.
>
> --
> Andrew J. Kelly, SQL Server MVP
> TargitInteractive
>
>
> "rich" <rjs211@optonline.net> wrote in message
> news:33Xw9.29600$S44.12547@news4.srv.hcvlny.cv.net...
> > thanks for all the info so far, but can someone tell me if it is normal
to
> > have 800 plus connections (with 90 users) as i stated before. i read
> > somewhere that every user conection is allocated about 40,000 bytes of
> > memory and if these should be closed when not in use
> >
> > thanks again everyone
> > --
> > Rich
> >
> > "rich" <rjs211@optonline.net> wrote in message
> > news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> > > first of all i'm not an sql expert at no means and don't pretend to be
> > > but the application developer keeps saying that my netwrok is at fault
> > > here is my configuration
> > > compaq ml530 server
> > > 2 pentium III 800 mhz xeon processors
> > > 4 gb memory
> > > 30 gig scsci raid drive array
> > > the only thing runing on this server is sql 7
> > > with mcafee netshield
> > > network consists of workstations all with 100 mb nic cards, and cisco
> 100
> > mb
> > > switches
> > > with a couple of 10mb hubs for small groups
> > >
> > > we are using sql server 7 in a medical application, it is used for
> > > appointment scheduling
> > > accounting - billing, posting charges, posting payments
> > > demographic patient information
> > > insurance information
> > > provider (doctor iinformation - insurance company id codes etc )
> > > 60,000 pateint records
> > > and in all about 1.7 million total records
> > > the application developer will not let us delete or archive and old or
> > > duplicate information
> > > the client side is written in delphi I was told
> > > we constantly have about 80 -90 users connected and workling on the
> > database
> > > it's so slow it's painfull
> > > once my cisco switches all went down at the same time and one group
> using
> > > the 10mb
> > > hubs called me and asked what i did, the system was faster, my only
> answer
> > > and
> > > summation was less users on line
> > > we now have 3 people who come in on the weekend when nobody is on the
> > system
> > > and
> > > they say the system flies
> > > also the server task manager show me that SQLSERVER.EXE is using close
> to
> > > 100% of the
> > > processors most of the time and memory used is about 1.8gb
> > > i got and sql monitor to look at what was going on and it has a
> connection
> > > counter and that show
> > > over 800 user connections
> > > when i look in computer managment console and shared files some people
> > have
> > > 17 to 25 files open
> > > i had an sql programmer look at my sql server and she said they are
> doing
> > > things with procedures
> > > that can be done better - what i don't know but i need help with this
> > > problem
> > > anyone know what can be done ?
> > >
> > > thanks in advance
> > > --
> > > Rich
> > >
> > >
> >
> >
>
>
| |
| Dan Guzman 2002-11-03, 2:23 pm |
| The numerous open connections may waste memory resources but shouldn't
have a major performance impact.
SQL connections will appear as open files in the server mmc only when
clients connecting via named pipes. In this case, the file name will be
'\\pipe\sql\query' (default). These are deleted when the connection or
application is closed so the sessions you observe may not be related to
SQL Server connections.
To list open SQL Server connections regardless of the protocol used,
execute sp_who from Query Analyzer. With Delphi, a possible cause of
numerous open connections per application is the use of components like
TTable, TQuery and data-bound controls. Each instance may require a
separate connection depending on the programming technique used.
However, before spend a lot of time trying to reduce the number of
connections, I suggest you first determine the cause of the CPU
bottleneck. One or two bad queries can bring the server to its knees.
You might consider the services of an experienced DBA with SQL and
application programming skills as well. A SQL programmer can correct
poorly written procs (which will certainly help) but database design and
application programming are part of the performance equation.
--
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"rich" <rjs211@optonline.net> wrote in message
news:yhbx9.394$0x.208@news4.srv.hcvlny.cv.net...
> hi andrew
> thanks for your response
> i'm with you that 90 users don't need 800 connections open but the
frontend
> is written so that all you can do
> is open files and have no option to close a connection (maybe i'm not
saying
> this correctly) but if a user
> goes into the patient file to make a new appointment and the into the
> appointment file to complete the appoinmtment i can understand both
files
> staying open because those users are always using those files
> it's the user that opens other files like accounting, insurance, and
many
> others but these files never get closed
> i have looking at open files in the management console and some users
have
> 20 + files open for days at a time
> (they never closed the application, but thats another story)
> also every night i have the i run a task to shut doen sql server and
restart
> it, but these connections still exsist
> i have to make everybody log off the application sometimes and
shutdown the
> server and restart to free u pall these connections
> is there anything i can have done to the sql server database, as the
> frontend developer denies anything is wrong with his application or
database
> and keeps blaming it on the hardware. (what else is new) like i said
before
> i had an sql server programmer (thru a friend who knows her ) look at
the
> database and she said she saw problems that could be fixed, i would
like a
> second opinion but find it hard to find sql programmers. do you know
of any
> good sql programmers in the new york city area and if so give me a way
to
> get in contact with them.
>
> thanks very much for you time
>
> rich schofield
>
> --
> Rich
> "Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
> news:OQB7Pf0gCHA.1760@tkmsftngp12...
> > Probably not normal but not imposable. I have seen very poorly
written
> > front ends that open way more connections than need be. Chances of
your
> 90
> > users really needing 800 open connections is slim. I would pick one
user
> > and study all the open connections to see what they are doing. More
than
> > likely they are opening them and not closing them when done.
> >
> > --
> > Andrew J. Kelly, SQL Server MVP
> > TargitInteractive
> >
> >
> > "rich" <rjs211@optonline.net> wrote in message
> > news:33Xw9.29600$S44.12547@news4.srv.hcvlny.cv.net...
> > > thanks for all the info so far, but can someone tell me if it is
normal
> to
> > > have 800 plus connections (with 90 users) as i stated before. i
read[
color=darkred]
> > > somewhere that every user conection is allocated about 40,000[/color]
bytes of[co
lor=darkred]
> > > memory and if these should be closed when not in use
> > >
> > > thanks again everyone
> > > --
> > > Rich
> > >
> > > "rich" <rjs211@optonline.net> wrote in message
> > > news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> > > > first of all i'm not an sql expert at no means and don't pretend[/color]
to be[co
lor=darkred]
> > > > but the application developer keeps saying that my netwrok is at[/color]
fault
> > > > here is my configuration
> > > > compaq ml530 server
> > > > 2 pentium III 800 mhz xeon processors
> > > > 4 gb memory
> > > > 30 gig scsci raid drive array
> > > > the only thing runing on this server is sql 7
> > > > with mcafee netshield
> > > > network consists of workstations all with 100 mb nic cards, and
cisco
> > 100
> > > mb
> > > > switches
> > > > with a couple of 10mb hubs for small groups
> > > >
> > > > we are using sql server 7 in a medical application, it is used
for[c
olor=darkred]
> > > > appointment scheduling
> > > > accounting - billing, posting charges, posting payments
> > > > demographic patient information
> > > > insurance information
> > > > provider (doctor iinformation - insurance company id codes etc )
> > > > 60,000 pateint records
> > > > and in all about 1.7 million total records
> > > > the application developer will not let us delete or archive and[/color]
old or[co
lor=darkred]
> > > > duplicate information
> > > > the client side is written in delphi I was told
> > > > we constantly have about 80 -90 users connected and workling on[/color]
the[c
olor=darkred]
> > > database
> > > > it's so slow it's painfull
> > > > once my cisco switches all went down at the same time and one[/color]
group
> > using
> > > > the 10mb
> > > > hubs called me and asked what i did, the system was faster, my
only
> > answer
> > > > and
> > > > summation was less users on line
> > > > we now have 3 people who come in on the weekend when nobody is
on the[c
olor=darkred]
> > > system
> > > > and
> > > > they say the system flies
> > > > also the server task manager show me that SQLSERVER.EXE is using[/color]
close
> > to
> > > > 100% of the
> > > > processors most of the time and memory used is about 1.8gb
> > > > i got and sql monitor to look at what was going on and it has a
> > connection
> > > > counter and that show
> > > > over 800 user connections
> > > > when i look in computer managment console and shared files some
people
> > > have
> > > > 17 to 25 files open
> > > > i had an sql programmer look at my sql server and she said they
are
> > doing
> > > > things with procedures
> > > > that can be done better - what i don't know but i need help with
this[
color=darkred]
> > > > problem
> > > > anyone know what can be done ?
> > > >
> > > > thanks in advance
> > > > --
> > > > Rich
> > > >
> > > >
> > >
> > >
> >
> >
>
>[/color]
| |
| Andrew J. Kelly 2002-11-03, 4:23 pm |
| >second opinion but find it hard to find sql programmers. do you know of any
>good sql programmers in the new york city area and if so give me a way to
>get in contact with them.
Well the best sql programmer I know of in the NYC area is BP. I can't speak
for him on his availability or interest in this but if he is I am sure he
will let you know.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"rich" <rjs211@optonline.net> wrote in message
news:yhbx9.394$0x.208@news4.srv.hcvlny.cv.net...
> hi andrew
> thanks for your response
> i'm with you that 90 users don't need 800 connections open but the
frontend
> is written so that all you can do
> is open files and have no option to close a connection (maybe i'm not
saying
> this correctly) but if a user
> goes into the patient file to make a new appointment and the into the
> appointment file to complete the appoinmtment i can understand both files
> staying open because those users are always using those files
> it's the user that opens other files like accounting, insurance, and many
> others but these files never get closed
> i have looking at open files in the management console and some users have
> 20 + files open for days at a time
> (they never closed the application, but thats another story)
> also every night i have the i run a task to shut doen sql server and
restart
> it, but these connections still exsist
> i have to make everybody log off the application sometimes and shutdown
the
> server and restart to free u pall these connections
> is there anything i can have done to the sql server database, as the
> frontend developer denies anything is wrong with his application or
database
> and keeps blaming it on the hardware. (what else is new) like i said
before
> i had an sql server programmer (thru a friend who knows her ) look at the
> database and she said she saw problems that could be fixed, i would like a
> second opinion but find it hard to find sql programmers. do you know of
any
> good sql programmers in the new york city area and if so give me a way to
> get in contact with them.
>
> thanks very much for you time
>
> rich schofield
>
> --
> Rich
> "Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
> news:OQB7Pf0gCHA.1760@tkmsftngp12...
> > Probably not normal but not imposable. I have seen very poorly written
> > front ends that open way more connections than need be. Chances of your
> 90
> > users really needing 800 open connections is slim. I would pick one
user
> > and study all the open connections to see what they are doing. More
than
> > likely they are opening them and not closing them when done.
> >
> > --
> > Andrew J. Kelly, SQL Server MVP
> > TargitInteractive
> >
> >
> > "rich" <rjs211@optonline.net> wrote in message
> > news:33Xw9.29600$S44.12547@news4.srv.hcvlny.cv.net...
> > > thanks for all the info so far, but can someone tell me if it is
normal
> to
> > > have 800 plus connections (with 90 users) as i stated before. i read
> > > somewhere that every user conection is allocated about 40,000 bytes of
> > > memory and if these should be closed when not in use
> > >
> > > thanks again everyone
> > > --
> > > Rich
> > >
> > > "rich" <rjs211@optonline.net> wrote in message
> > > news:jUGw9.17170$S44.12715@news4.srv.hcvlny.cv.net...
> > > > first of all i'm not an sql expert at no means and don't pretend to
be[co
lor=darkred]
> > > > but the application developer keeps saying that my netwrok is at[/color]
fault
> > > > here is my configuration
> > > > compaq ml530 server
> > > > 2 pentium III 800 mhz xeon processors
> > > > 4 gb memory
> > > > 30 gig scsci raid drive array
> > > > the only thing runing on this server is sql 7
> > > > with mcafee netshield
> > > > network consists of workstations all with 100 mb nic cards, and
cisco
> > 100
> > > mb
> > > > switches
> > > > with a couple of 10mb hubs for small groups
> > > >
> > > > we are using sql server 7 in a medical application, it is used for
> > > > appointment scheduling
> > > > accounting - billing, posting charges, posting payments
> > > > demographic patient information
> > > > insurance information
> > > > provider (doctor iinformation - insurance company id codes etc )
> > > > 60,000 pateint records
> > > > and in all about 1.7 million total records
> > > > the application developer will not let us delete or archive and old
or[co
lor=darkred]
> > > > duplicate information
> > > > the client side is written in delphi I was told
> > > > we constantly have about 80 -90 users connected and workling on the
> > > database
> > > > it's so slow it's painfull
> > > > once my cisco switches all went down at the same time and one group
> > using
> > > > the 10mb
> > > > hubs called me and asked what i did, the system was faster, my only
> > answer
> > > > and
> > > > summation was less users on line
> > > > we now have 3 people who come in on the weekend when nobody is on[/color]
the[c
olor=darkred]
> > > system
> > > > and
> > > > they say the system flies
> > > > also the server task manager show me that SQLSERVER.EXE is using[/color]
close
> > to
> > > > 100% of the
> > > > processors most of the time and memory used is about 1.8gb
> > > > i got and sql monitor to look at what was going on and it has a
> > connection
> > > > counter and that show
> > > > over 800 user connections
> > > > when i look in computer managment console and shared files some
people
> > > have
> > > > 17 to 25 files open
> > > > i had an sql programmer look at my sql server and she said they are
> > doing
> > > > things with procedures
> > > > that can be done better - what i don't know but i need help with
this[
color=darkred]
> > > > problem
> > > > anyone know what can be done ?
> > > >
> > > > thanks in advance
> > > > --
> > > > Rich
> > > >
> > > >
> > >
> > >
> >
> >
>
>[/color]
|
|
|
|
|