Click here to Skip to main content
15,887,027 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
Hello every one,

I have a SQL Server 2005 database in a server machine. This server is also the domain controller. More than 100 client machines are connected to this machine.
Current connection is using SQL Authentication to connect to database.
The application is very slow
Will the speed increase if the clients are using windows authentication ?
Or is there any alternate way of connecting to the central database ?
Posted
Updated 18-Jul-11 4:49am
v2

No, I do not think so.

Many things can impact performance on the application and the SQL Server.

The first thing is the application that connects to the database.
How does SQL SELECT statements performs (Index etc), does the application use DataSet/DataTable or does the application always do a SQL SELECT every time.

And then the SQL Server. How larges is the database, how much CPU/RAM/HDD "power" does it has. Network connection...

Changing from SQL Auth to Windows Auth, does not solve your problem.
 
Share this answer
 
Comments
walterhevedeich 18-Jul-11 9:10am    
Good point. 5ed.
Kim Togo 18-Jul-11 10:27am    
Thanks
[no name] 20-Jul-11 1:57am    
Excellent.
+5
Kim Togo 20-Jul-11 7:09am    
Thanks
"Will the speed increase if the clients are using windows authentication ?"
Probably not.

Before you can speed up anything, you need to get some measurements, so that you can confirm if anything you do makes a difference, and hopefully also check where the bottleneck is.

It could be your DB Server, your network, your application, or in your users imaginations. First, find out where.

For example, your application could be issuing all queries in the form:
SELECT * FROM myTable
When what it actually needs is
SELECT address FROM myTable WHERE userId=7


Start with trying to time what is happening, and when. If you can do timings when everyone else has gone home, that helps.

Then google: "speed up sql database queries" will give a lot of ideas.
It suggested these two: http://www.catswhocode.com/blog/10-sql-tips-to-speed-up-your-database[^] and http://www.ajaxline.com/32-tips-to-speed-up-your-mysql-queries[^] (though I would disagree about the first tip, most of them are relevant to MsSql as well)
 
Share this answer
 
Comments
Kim Togo 18-Jul-11 10:28am    
Good points.
[no name] 20-Jul-11 1:57am    
Excellent. +5.
All above solutions are very good. And i hope mine will be good too...
Try to change windows authentication to "single" sql server user ("single" becouse it differ from single user database on ms sql server). There is only one condition: you need to create authentication database and log-on window (where user types his login and password) ;)
It's simple to use and very simple to manage:
1) reading user permissions from database it's much faster then read it from windows-rihts,
2) there is only one place to manage users permissions,
3) you can set up users permission to each database on ms sql server,
4) you can set up permissions to your applications (using rules, department name and others)
4) you don't need to change windows rights, permissions,
5) only one user can connect to the database.

I hope it's understandable. I know my english is not perfect ;)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900