Performance Problems With MS SQL 6.5 With > 400 Users

Dec 19, 1999

I administer a MS SQL Server 6.5 server which contains one principle user database. This application maintains an average of 400 to 450 active user connections under normal use. The server hardware consists of 4 PP200 CPU's, 1 Gb RAM, ATM NIC card, 64 Mb cache on the controller card and a RAID 5 configured storage with over 80 Gb of space. We have problems almost daily where users have trouble obtaining information from the database or fail to connect. The only errors I see in the error.log are "Lost connect" errors which are created due to users abruptly disconnecting from the database because they are tired of waiting for a response. I've ran a number of performance monitor checks which generally come up as expected. I have a few checks where they indicate that WinNT may not have enough memory but the memory allocation is approx. 25% WinNT (250 Mb) and 75% MS SQL Server (750 Mb). This should be more than enough for the WinNT OS.

Does anyone have any suggestions as to what I can do to help performance or other checks I can make that would tell me more of why I am having problems?

Any suggestions would be greatly appreciated.

View 2 Replies


ADVERTISEMENT

Performance Affected For Selected Users

Jan 24, 2005

Hi
I have 400 mb db with simple recovery
and 1 mb log file running on sql 2000 sp3

database reorgenazed with shrink db option once a day at 6 PM as part of maintance plan

db used with Powerbuilder application
application and db structure was not changed for last 6 month.

Some users complaining about performance.
When I run trace I don't see any query running more then 0.5 sec, while users complain it takes 3-5 sec to open a window or application freeze.
When I ask user reconnect and repeat the task ,everthing is fine.

How to identify is it db or application problem?



Thanks

View 5 Replies View Related

Web Synchonization Performance && Concurrent Users

May 24, 2006

Hi

I need some rough figures for replication performance. Can anyone give an idea of the number of concurrent subscribers a single IIS server can safely handle before having to move to load balancing with multiple IIS servers.

I would estimate the average daily row changes to be in the region of 500 to 2500 per subscriber.

Any ideas?

Many thanks

RL

View 1 Replies View Related

Reporting Services :: Adding (new) Child Domain Users To SSRS As System Users?

Jul 28, 2015

We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.

I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.

Is there any additional step I should/could take to get this active?

View 5 Replies View Related

Why Out Of The Blue Would VPN Users Be Unable To Connect To Database And Local Users Are Unaffected?

Mar 6, 2008

I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!

View 6 Replies View Related

SQL Security :: Did Not Create Any New Users And There Are No Other Users Listed In Accounts Section

Sep 28, 2015

I am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.

View 2 Replies View Related

Stored Procedure To Get All Users Or All Users Of A Specific Country

Apr 30, 2008

hi alli've got two tables called "webusers" (id, name, fk_country) and "countries" (id, name)
at the meantime, i've a search-page where i can fill a form to search users. in the dropdown to select the country i included an option which is called "all countries".
now the problem is: how can i make a stored procedure that makes a restriction to the fk_country depending on the submitted fk_country parameter?it should be something like
SELECT * FROM webusers(if @fk_country > 0, which is the value for "all countries"){    WHERE fk_country = @fk_country}
who has an idea how to solve this problem?

View 9 Replies View Related

Difference Between Database -- &&> Users And Security --&&> Users

Nov 28, 2006

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

View 1 Replies View Related

List Users Then Disconnect Users

Jun 4, 2008

I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.

can this be done in SQL and if so how?

View 1 Replies View Related

Users Get Blocked By Other Users Alot

Sep 26, 2007

We are using Navision with SQL server 2003.

What kind of methods is there out there to reduce hwo often this happens?

View 10 Replies View Related

[Performance Discussion] To Schedule A Time For Mssql Command, Which Way Would Be Faster And Get A Better Performance?

Sep 12, 2004

1. Use mssql server agent service to take the schedule
2. Use a .NET windows service with timers to call SqlClientConnection

above, which way would be faster and get a better performance?

View 2 Replies View Related

Extremely Poor Query Performance - Identical DBs Different Performance

Jun 23, 2006

Hello Everyone,I have a very complex performance issue with our production database.Here's the scenario. We have a production webserver server and adevelopment web server. Both are running SQL Server 2000.I encounted various performance issues with the production server with aparticular query. It would take approximately 22 seconds to return 100rows, thats about 0.22 seconds per row. Note: I ran the query in singleuser mode. So I tested the query on the Development server by taking abackup (.dmp) of the database and moving it onto the dev server. I ranthe same query and found that it ran in less than a second.I took a look at the query execution plan and I found that they we'rethe exact same in both cases.Then I took a look at the various index's, and again I found nodifferences in the table indices.If both databases are identical, I'm assumeing that the issue is relatedto some external hardware issue like: disk space, memory etc. Or couldit be OS software related issues, like service packs, SQL Serverconfiguations etc.Here's what I've done to rule out some obvious hardware issues on theprod server:1. Moved all extraneous files to a secondary harddrive to free up spaceon the primary harddrive. There is 55gb's of free space on the disk.2. Applied SQL Server SP4 service packs3. Defragmented the primary harddrive4. Applied all Windows Server 2003 updatesHere is the prod servers system specs:2x Intel Xeon 2.67GHZTotal Physical Memory 2GB, Available Physical Memory 815MBWindows Server 2003 SE /w SP1Here is the dev serers system specs:2x Intel Xeon 2.80GHz2GB DDR2-SDRAMWindows Server 2003 SE /w SP1I'm not sure what else to do, the query performance is an order ofmagnitude difference and I can't explain it. To me its is a hardware oroperating system related issue.Any Ideas would help me greatly!Thanks,Brian T*** Sent via Developersdex http://www.developersdex.com ***

View 2 Replies View Related

Very Poor Performance - Identical DBs But Different Performance

Jun 22, 2006

Hello Everyone,I have a very complex performance issue with our production database.Here's the scenario. We have a production webserver server and adevelopment web server. Both are running SQL Server 2000.I encounted various performance issues with the production server witha particular query. It would take approximately 22 seconds to return100 rows, thats about 0.22 seconds per row. Note: I ran the query insingle user mode. So I tested the query on the Development server bytaking a backup (.dmp) of the database and moving it onto the devserver. I ran the same query and found that it ran in less than asecond.I took a look at the query execution plan and I found that they we'rethe exact same in both cases.Then I took a look at the various index's, and again I found nodifferences in the table indices.If both databases are identical, I'm assumeing that the issue isrelated to some external hardware issue like: disk space, memory etc.Or could it be OS software related issues, like service packs, SQLServer configuations etc.Here's what I've done to rule out some obvious hardware issues on theprod server:1. Moved all extraneous files to a secondary harddrive to free up spaceon the primary harddrive. There is 55gb's of free space on the disk.2. Applied SQL Server SP4 service packs3. Defragmented the primary harddrive4. Applied all Windows Server 2003 updatesHere is the prod servers system specs:2x Intel Xeon 2.67GHZTotal Physical Memory 2GB, Available Physical Memory 815MBWindows Server 2003 SE /w SP1Here is the dev serers system specs:2x Intel Xeon 2.80GHz2GB DDR2-SDRAMWindows Server 2003 SE /w SP1I'm not sure what else to do, the query performance is an order ofmagnitude difference and I can't explain it. To me its is a hardware oroperating systemrelated issue.Any Ideas would help me greatly!Thanks,Brian T

View 2 Replies View Related

Db Users Mix Up

Feb 28, 2006

Hello:
I am having a problem understanding the db users.
I am working on a DNN site, and having troubles with db users permissions.

I want to know what is the DBO?
I have a user in my database, that is assigned "public".

In my application usually, what should i do:
1- Login with the public user, create tables, views, sp, add data ...
2- Use the dbo always?

In my application, I will be using the public user in the connections string.

Can you help please.

View 3 Replies View Related

SQL 7 Users

Nov 30, 2001

I have moved several SQL 7 databases from one server to another. The databases
are attached, and I can see all the tables,etc. However, I can only see 1 user, that being dbo, therefore users cannot log into the db. HELP

View 1 Replies View Related

SQL 7 Users

Dec 16, 2004

Hiya,

I need to get a copy of the users table from the master DB to another machine I have.

This is to include permissions / passwords etc

anyway this can be done? Cheers!

View 2 Replies View Related

Dbo Cannot Add Users In SQL DB

Jan 30, 2004

I'm using SQL 2000 and I'm the database owner. I have been running tests with stored procedures to add logins, revoke logins, add db access, revoke db access etc.

Now I can't seem to add users to the database. I've tried using 'dbo' and 'domainmy_username' but I'm denied permission to run any stored procedures to try and add myself to the db_accessadmin or sysadmin roles.

I've tried the New Database User dialog and choose <new> under login name. I browse for the user name on my domain, click OK, and I get the message 'You must be logged in as 'sa' or a member of sysadmin or securityadmin to perform this operation.'

I thought the dbo always had full permissions on his database. This doesn't make sense to me. :confused:

The only thing I can figure is my permissions have been revoked on the master db.

Can anyone help?

View 3 Replies View Related

Users

Apr 22, 2004

Is there a way to get a list of users from SQL who are connected and using the database?

Thanks

View 8 Replies View Related

Users !!

Jun 10, 2006

hi
can you tell me how to creat users in MS SQL Server 2005 ??
i tried but i cannot..
my server name is : TOOLSBOXSQLEXPRESS
can you guide me to lesson or book talking about how to creat users ??
and can you guide me to book talking about how to creat users and roles ... etc
thank you

View 3 Replies View Related

Users

Jan 23, 2008

My database is being moved from SQL 2000 to SQL 2005. Is there a way to copy a User from the old database to the new one, call it a different name and let it have all the same rights as the old one.

View 3 Replies View Related

? About Users

Jan 7, 2008

How do I setup a user to access the my sql server database. I do not wantto give him the admin account login.

View 1 Replies View Related

No Of Users

Aug 19, 2006

Hi,

I am using sql server express edition. I have centralised database running in windows XP home edtion version. I can connect only 5 clinet computers at a time to the main database. I need to connect 8 clients to the main database. Each client is running with windows xp home edition. Thanks in advance

Anil





View 3 Replies View Related

SQL Server And Users

Aug 17, 2006

Hello,
I am new to this forum, and ASP .NET 2.0. I watched the tutorial on how to use the login control with SQL Server 2005 Express, and was able to duplicate it easily. However, I tried to see if I could do the same thing with SQL Server 2005 that is hosted by my hosting company, and I was unable to get it to work. I am using Visual Web Developer 2005 Express, at least until I get VS 2005 in a few weeks, and I am able to connect to the SQL Server. I tried following the tutorial on this site step by step, and some of the things they used to set it up I could not use. In the tutorial VWD creates the table automatically. If I use the hosted database, do I need to create the table, or is there a way for VWD to do it that I haven't figured out yet.
Any help and additional information that I might need to know would be great.
Thank you for your help.
Ben

View 2 Replies View Related

.NET Membership And SQL Users (not Sa/dbo)

Mar 14, 2007

I recently moved my .NET project out to production, the server is Windows 2003 running SQL 2005. My developement server was a Windows XP running SQL 2005. Here is my issue.
Under development I created a specific user to log in as, created a role and specified exactly what application specific stored procedures etc. that user was allowed access to. Everything worked fine. Backing that database up and restoring it to the new server, when I attempt to log in as the user (and yes I re-created the login, with the user, just as I did on the development server), I get this error... 
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'MoldKit', schema 'dbo'.
So I attempt to login as SA, and everything works... so I assign the db_owner role to my user and login, everything works... problem being they shouldn't be db_owner. And they're most definitely not assigned this role on development. I even went so far as to delete the database, and recreate it from scratch using the aspnet_regsql.exe and I get the same error. Anyone have any idea why this is happening, or the proper roles I need to assign so the user isn't a dbo, but can still call all the required aspnet procedures. Or could this be some other issue caused by 2003?
I've seen this error in a lot of posts, but never once saw a definiative answer to what causes it and and what the fix is.

View 1 Replies View Related

Different SQL Server Users On ASP.Net

May 3, 2007

Hi there,
When conecting to a MS SQL Server 2005, I could define in my connection string Windows Authentication.
What account it will be used? The one used by IIS (I still don't know the user ASP.net runs, if it is independent of IIS or not)?
And if I whant that some aspx pages have diferente acess rights? I need to use SQL Server Authentication with diferent users created in MS SQL Server right? 
In ASP.net, what is best practice: Have one SQL account, and make users access rights in Business Logic, or have different SQL Accounts por the diferent access rights I whant in every page?
Sorry if this are basic questions, but In the find's I made, I saw very confusion ideas.
Thanks in advance, and sorry my english.
Alberto Ferreira

View 1 Replies View Related

Users Database

Jan 31, 2008

how can i create a users database to store users infos (names pictures...) ??
thx for taking time to read this

View 2 Replies View Related

Users Question

Apr 17, 2006

Hi All,
Probably this is an easy question to many of you, but I'm not quite sure.  I have imported a database  to my local, and there are a lot of (system) users attached to it.  My goal is to update the password for the system user.
I have researched for a while, I find a way to update the Master.. sysxlogin.
So I wonder it is ALWAYS the users who have added to individul databases, their username will always in the Master..sysxlogin table?   As I have imported the database from my client, so the username are not in the sysxlogin table. 
Thank you for your help.

View 1 Replies View Related

Users, Permissions.. Etc.

May 9, 2002

Hi there!
I'm developing an application and i need to do the next thing:
I need to make a process, but this process just need to be done, when nobody else is modyfing datas in the database.

Is there anyway i could check this? I have read about the sp_who stored procedure but this one return all the activity in all the databases, and i just need to check in one specifically. And there's another issue, we all access with the user dbo to the database...

Any help will be appreciated..

View 2 Replies View Related

How Do You Disconnect Users?

Mar 21, 2001

Does anybody have a job where it will disconnect certain users from the database

What I would like to do is schedule a job that will run at 11:00pm that will disconnect certain users (not all of them). This program should also kill any jobs that these users may be running.

I running into a problem occasionally, where a certain program hangs up and will not release its DB locks. This then keeps a couple of the nightly batch jobs from running.

(I run on SQL SERVER 7.0 on a NT server)


Matt Atkinson, mratkinson@www.com

View 2 Replies View Related

Adding Users To SQL 7

May 25, 2001

Have small network of NT workstations, A PDC and BDC. We have one SQL database on the PDC and two others on the BDC. I added a new machine to the network, added users to that machine. When I try to add the new user, (Not Machine) to the database on the BDC, using security, add new user, I get the following message: Microsoft SQL-DMO ( ODBC SQL Statement 42000)
Error 15401: Windows NT user or group "domainnameusername" not found Check the name again.

The user 01 is listed on both the PDC and the BDC. I am totally baffled by this. Any help would be appreciated.

Stephen

View 1 Replies View Related

Maximum Users

May 29, 2001

Can anyone tell me the maximum number of (if there is a maximum) for the following :-

1. SQL Server Users per Database
2. Roles per Database
3. Connections per Server
4. Logins per Server

Thanks.

View 1 Replies View Related

How To COunt Users

Sep 12, 2001

Hi Experts,
My Question Is
How To Count No OF Users presently online From Sql Server 7.0
PLease tell me as early as possible...

View 1 Replies View Related

How To Export Users From A DB To Another

May 29, 2000

I have two database. one for work, and another to study and developement.
How I can export the users from the database Work to the database developement.

Luiz Lucasi
Rio de Janeiro - Brazil
luca@icebox.com.br

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved