Hi All,
I know it is post on outdated post but I have a little query regarding the DC and DB server setting in the network.
At one of the client place we are facing a very slow ms-sql 2008 access when > 50 users are working. The application is .net application.
The configuration is as follows.
1.Data server xeon processor (2 processors) with 32 GB RAM
2.600 GB SAS harddisk
3.MS-SQL 2008
4.Windows 2008 R2 OS
The network is local area network and is security is controlled by a domain controller which is not in the same network but is remotely(internet) located in another location (4 Mbps) dedicated lease line.
I think the DC authentication while accessing the DB will make it to run slow. Please guide.