Increasing User Connections
Nov 29, 2000To increase user connections in SQL 6.5 do I have to first increase the memory configuration numbers?
Current memory config is at 8192.
ADVERTISEMENT
Problem With Increasing Connections
Oct 30, 1998I have increased the number of connections my Sql server will allow, and now I cannot restart my SQL Server, it keeps creashing and giving me an error message, has anybody else come across this, or know how I can restart my SQL server so I can atleast do a bit of work today!
View 1 Replies View Related128 MB Of Ram And 50 User Connections Do We Need More RAM?
Apr 5, 2001Develpers complain that Sql server is slow
We running 4 databases about 400 MB each.(hotel reservations ...)
Buffer cache ( 99.8) but sometimes it goes down to (62.0)
memory configuration Dynamic
Do we really need more memory for 50 users or what should I check in the first place ?
Thanks
User Connections
Oct 27, 2000We are using SQL Server 7.0. Can anyone tell me the difference between setting max connections to 150 versus setting it to 0 for unlimited. We have an application that was running slow with the 150 connections set. We changed it to 0 for unlimited and now the application flies.
Can anyone explain this? Does SQL Server do something different with these settings?
Thanks!
User Connections.
Nov 27, 2000I'm locked out of my SQL server because user connections are set at '5' and apparently there are already '5' users connected.
So.. I can't login as SA or anyone to change the option. We've rebooted, disconnected from the network, and still '5' users seem to be connected.
What could be causing this.. Or how can I override the connections without logging in.
User Connections !!!
Mar 8, 2001I'm running SQl Server 7.0 SP1.
Currently the number of simulteneous user connections is set to 0 (0=unlimited).
But one of remote users when trying to connect to the server is getting sql error message that "There are more then 10 users connected".
Should I change "user connections" server configuration?
Thank you
Lena
User Connections
Feb 9, 1999Hi guys,
Help me please to clarify following situation.
My application has 20.000 users.
How many simultaneously user connections should I'll set?
Thanks,
Alona
User Connections
Jul 27, 1999I am trying to shrink my tempdb using the following sql 6.5 commands:
sp_dboption 'tempdb', 'single user', true
dbcc shrinkdb(tempdb)
I get the following message: "Attempt to set 'tempdb' database to single user mode failed because the usage count is 3. Make sure that no other users are currently using this database and rerun CHECKPOINT."
When I do a 'sp_who active' it returns about 5 spids but they are things like Mirror Handler, Lazy Writer, Checkpoint Sleep, RA Manager, and Select. I am not able to 'kill' the spids. I get 'Only users processes are able to be killed.' How do I identifiy the 3 users that sql is saying are connected to the tempdb database? And how do I remove the 3 users?
Thanks in advance.
Kevin
User Connections
Aug 24, 1998Hi all!
In SQL 6.5, if I increase my user connections, should I also increase the amount of RAM allocated to SQL?
Any help would be appreciated.
Thanks
Toni
No.Of User Connections
May 11, 1999I need to know the number of client licences that i require for a SQL Server. I want to monitor the
Server for a period of a week or so to find out the max..no of user connections during that time
so that i can fix the no. of user connections parameter.
i have tried using the foll Perf monitor counters :
No of open user connections
Client Count
Max Client Count
Client Limit
and am still confused about the numbers.
Can anyone throw some light on the difference in these counters and which one do i go by for
calculating my licenses .
Thanks
SQL User Connections
Mar 29, 2006I am in the process of installing 7 remote desktop computers that are furnishing data to a SQL server. We will also have 40-50 Managers/Supervisors who will have access to the database for information retrieval. Are there any tools available that would allow me to monitor who is connected to the Server? My main interest in monitoring are the 7 desktops which are permanently connected to the database. Until we have some history, I would like to make certain that we can maintain a good connection between the desktops and the server
View 1 Replies View RelatedHow Do I KILL All User Connections In One Go?
Oct 16, 2001How do I "KILL" all user connections in one go?
I need to perform a daily restore and have to manually kill multiple
user connections, its very time consuming. Is there an easier way?
Id be grateful if you can help me!
Many thanks,
Lauryn
User Connections (-f Option)
Nov 27, 2000I'm locked out of my SQL server because user connections are set at '5' and apparently there are already '5' users connected.
So.. I can't login as SA or anyone to change the option. We've rebooted, disconnected from the network, and still '5' users seem to be connected.
What could be causing this.. Or how can I override the connections without logging in.
Killing User Connections
Oct 19, 2000Is there a way to kill all user connections to a database using T-SQL?
Thanks!
Maximum User Connections
Jul 29, 1999We have a production server that is configured to 100 user connections.
Without any reason, the maximum connections had been exceeded and users
can no longer access the sql. But if you sp_who , it displayed only
4 user connections. Since, I have an open connection before this error
happens, i was able to execute sp_who. This happened 4 times since we
installed the sql server. the version is 6.50.422 sp5a with hotfix.
To all gurus out there, can you give light into this problem?
Thanks in advance.
Mysteriously Max Out On User Connections
Mar 1, 1999Recently, my SQL Server has started getting:
"Unable to connect. The maxinum of '100' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure."
The server has to be rebooted to recover.
What's odd is that this occurs during the weekend when only about 5-8 connections are used by various system processes. I can't tell yet what is sucking up the connections.
We use SQL 6.5 sp4 on NT4.0 sp3 for DEC Alpha. We are also using SQL Mail, Seagate Backup (with SQL drivers) and some cgis that talk to the database.
Any thoughts would be appreciated.
Darin Drewrey
DBA
Extensis Corp
User Connections And Out Of Memory
Apr 26, 1999I did something stupid. I was having a problem with my application of trusted connections exceeding 15. I changed the user connections to 30 without uping the server memory configuration. Now I am out of memory and can't establish a connection with the server to up the memory configuration. I don't want to have to reinstall sql 6.5 and loose my existing data. I am on a Netfinity server with 512 megs of memory. Any suggestions? And of course our NT tape backup unit is not set up for sql backup.
Also does 30 connections and 128 megs of sql memory sound ok for a non dedicated server. About 25 users connecting to the database at any given time?
User Connections Problem
Jun 6, 2001We are having a problem with the maximum number of user connections to sql. Currently we have a max of 500 connections and we are unable to connect to sql because the max number has been exceeded. The sql logs are flooded with repeated error messages about the user conncetions being maxed out.
Anyone has an idea why this could be happening? Also, can it be fixed by rebooting the server?
Thanks
Maximum User Connections?
Jul 23, 2005Newbie here.I've got my database set up in SQL 2000, and have started an Access adpfor a front end. I have 10 licenses, and at the moment the onlyaccesses are the server through Remote Desktop and one person into theADP. I started getting ODBC timeout errors when running a complexquery, so I started poking around. In the logs there's messages sayingthe maximum of 10 user connections has been reached, over and overagain. I'm not even certain that these problems are related, but itdoesn't look good.Why are all 10 connections used when there's only the server and oneclient? No one else has access to this server. And how can I stop theODBC timeout? That paticular complex query is the whole jsutificationfor using SQL over Access, so I kind of need it to work. :)Thanks in advance, maddman
View 8 Replies View RelatedHow To Find Out The Number Of User Connections
Aug 9, 2000I am using SQL 6.5 and I would like to know (using Isql/w)
the number of users connected to my server at any given time.
Thanks for your help in advance.
USer Connections Exceeded (ODS 17809)
Oct 28, 1999Hello ,
I get this message in the error log file (ODS17809) for sqlserver 6.5 on windows NT 4.0
Although this parameter is set to 50 which is more than enought for our environment. When I look up in current activity, I see only 4 users connected.
IS there a way to find , why this message comes up and how many actula connections (alive or hanging) are with the Sql server.
Well, I can increase the number of connections, but that is not the solution , as I would like to track/debug where all the connections are being used up.
thanks in advance for your help/suggestions
Mitesh Shah
mshah@princetonsoftech.com
Maximum Number Of Configured User Connections
Jul 27, 2001Hi,
Environment:
I have a Sqlserver 6.5 production server used for web based applications
Compaq 5500 4 GIG RAM, 4 processor
Sql Memory config on that server is 1048576 (which is 2048 MB)
and the run value is 640000 (which is 1250 MB).
runvalue for user connections was 500
We have only 90 user connections may increase upto 100 depends on the connections. We don't have any overload on that server.
Error: I was seeing
"unable to connect maximum no. of 500 configured user connections are already connected" in the error log.
Action Taken:
I increased the user connections to 600
and rebooted the server. Immediately the same error I can see in the error log. But we have only 20 user connections at that time. I can able to connect.
Please advise me to get rid of this error.
Thanks,
Anu.
What Does The Following User Instance Limitation Mean Only Local Connections Are Allowed
Mar 17, 2008I have been reading through the article pointed to by the link below on msdn and its documented that one functional limitation of user instances is "Only local connections are allowed." I didn't understand the technical details(meaning) of that limitation and hopefully some one might explain it to me so that i can understand it better.
View 6 Replies View RelatedStored Proc Failed To Kill User Connections?
Mar 27, 2000Hello:
I am working with an application unde mssql 6.5 ,sp4. We have a separate
database for reporting on a different box. Each night we load a backup into
the database from the production database.
I set up a stored procedure to kill all users connected to this reporting
database just before the load.
THe job looks like this under scheduled tasks as a cmdexec:
isql -U sa -P -d master -Q"exec killusersall_sp 7" -o
F:MSSQLatchjobs
evdb.log
This job died with the following message:
Process Exit Code 1. ...[-b On error batch abort] [-O use Old ISQL
behavior disables the following]<EOF> batch processingAuto console width
scalingWide messagesdefault errorlevel is -1 vs 1 [-? show syntax summary
(this screen)]
The killusersall is paramaterize sp that I pass the dbid of the database
for whom I want all users killed. I need to put the stored procedure in the
master because I egt the spid from sysprocesses.
I do not understand why the job died. Does it matter if I named the stored
procedure as sp_killusersall instead of killusersall_sp which I used.
Can any one advise me about how to get the job to run? Any assistance will
be greatly appreciated. Thanks you.
David Spaisman
User Login - How To Control Number Of Simultaneous Connections
Jul 30, 1998Hi everyone!
Is it possible to control the number of simultaneous connections one login id can have?
I`d like to avoid my users to share their login ids and passwords to help them enter data into the system.
Thanks,
Mauricio
Does Sql Express License Limits Number Of User / Connections?
Apr 25, 2006I can't find the answer...it just talk about the CPU / ram /database limit. thanks for you help!
View 1 Replies View RelatedSetup And Upgrade :: Enable User Connections Limit Per Microsoft Database
Jun 26, 2015How does one enable sql connections limits for user connections per new and existing databases? how to do it on whole server per database but not set a limit per user.Looks like this must be run on each databases but what if you have 100s of databases:
USE AdventureWorks2012 ;
GO
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE ;
GO
EXEC sp_configure 'user connections', 325 ;
GO
RECONFIGURE;
GO
Maximizing User Connections Sql Server 2000 Vs Sql Server 7
Nov 1, 2000What are the maximum number of user connections achievable for sql server 2000 (w/ win 2000 adv server), and how are they managed - compared with sql server 7.0 (w/ win nt 4.0)? Our group is looking at upgrading our dbase server from sql server 7.0 to sql server 2000.
HELP
Thanks in advance
Gunnar
gunnardl@yahoo.com
Increasing SQL Performance - Am I Right?
May 18, 2007Hi, I was aware of an idea that I want to share with you guys: Here's the thing, I have an Access DB that I will pass to SQL, optimizing its structure and data, to optimize then its performance. About this last issue, the present Access DB has some consultations very redundant. Take this example as "source code": Consultation A is made by selecting some fields with some conditions on consultations A and B. I want to end this. Consultation A is consultation A, B is B and C is C, they all are made by themselfs.However, a new idea came to light! This data is to be displaied on a Web application on VB.Net, and I want to show the results from consultation A, B and C, once per time, but all sequencially. What if I execute two commands, one reading consultation A (by a stored procedure), another to consultation B, and save that data in an arraylist of objects, and then generate consultation A based on those application objects that are alread instaned and ready to use, selecting the final data on those objects and not in the database? Am I making any mistake, or am I optimizing performance somehow? The final purpose is really getting the most performance as we can!Any tips on this?Thanks a lot!
View 3 Replies View RelatedIncreasing Speed
Jan 25, 2006I'm not sure if this is the right forum, but I have a general question about running/storing databases. I have been running a process with 60+ million records in one table and another 16 million in another table and it is taking forever to get everything imported in and run the appropriate queries. I've been doing this all on a desktop and I am anxious to learn of a more efficient, faster method of processing this amount of data.
What solution should I pursue if I am doing this work a few times a year so that it doesn't take three full days of processing to reach an answer with the data?
Thanks.
Increasing Memory
May 30, 2008I've received conflicting information from Microsoft personnel so thought I'd see what some thoughts here are.
In summary, we upgraded a server from SQL Server 2000 SP4 Standard to SQL Server 2005 SP2 Standard. This servers main purpose is to handle alot of merge replication to anonymous pull subscribers. We have some Transactional replication also occurring. There are 8GB memory on the server.
During the upgrade we ran into memory pressure on MemToLeave. We put the /3GB parameter in boot.ini and -g512 on the startup per Microsoft's suggestions. This got us past the upgrade process.
After the upgrade, we took off the boot.ini setting and the -g512. We enabled AWE and assigned 6GB to SQL Server. Then once in a while when the merge snapshots were running, we'd receive some "system out of memory" errors. I went ahead and put -g512 back on and haven't received the error since.
My question to Microsoft then was if we go to say 16GB of memory on the box and give say 14GB to SQL Server, would it be beneficial to set the -g option to a higher number. That's when I got into a discussion with the Microsoft person that SQL Server 2005 Standard would not use anything above 4GB, which is opposite what the Microsoft site says, others have said, and opposite to what I'm seeing for memory usage with DBCC MEMORYSTATUS showing the 6GB being used We'll be talking to our TAM about our suppport, specifically on Replication topics, as we've had some problems getting knowledgable support on this topic. If anyone knows of support outside of Microsoft on Replication topics, I'd love to hear about it.
Any thoughts on the tweaking of memory related to our environment? I know it may be site-specific and we may have to do some trial and error, but with:
1. Doing heavy merge replication processing on the server(1,500 subscribers).
2. say we get 16GB on the box(server is Windows 2003 SP2 Enterprise)
are there some suggestions on a -g setting to best utilize Buffer Pool and MemToLeave ? Some other things to do? Is there some process/method to help determine how best to define the memory settings? If there a way to see how much BPOOL and/or MemToLeave the system is using at a given moment? DBCC MEMORYSTATUS gives alot of info, but I'll be the first to admit that I don't know what alot of the info there is really telling me. If there some white paper, etc that would help determine what the system is doing memory-related, that'd be great to know.
Thanks for any help,
Doug
Increasing SAN Space On The Fly
Jun 4, 2008Hi,
one of our clients is running out of disk space on the SAN and I was simply wondering if it's possible to increase the disks on the fly without any major problems...? Should we take any special precausions? It's a clustered Win2k3 64-bit server with SQL Server 2005 Ent Edition...
--
Lumbago
.ldf Log File Increasing .... What Can I Do ?
Mar 28, 2008
Hi, i'm using SQL Server Express (9.0.2047).
My database's *.ldf file's size increasing everyday... How can i decrease it?
How can i make ldf file to small ?
Please, inform me.
Thank you.