Configuration for the database files is pretty poor, its all based in a single RAID 5 config. 3 spindles.

I know the disk...

Good point Jeff. How about when there is only one DBA ? and maybe a system admin. would you give SA passwords to non DBA's ?

TheSQLGuru (12/10/2009)

---

Dean, there are a LOT of variables here. I recommend you get a performance tuning professional in for a day to review your system and make recommendations as...

Thanks for the information. I have checked tempdb on system A and ran thesame code on Server B, Server B has a dedicated IO subsystem for tempdb.

SELECT substring(name,1,20) as 'Database',...

Jonathan Kehayias (12/9/2009)

---

There are a couple of things you could look at. If the bottleneck is not PFS contention and is instead a diskio problem, sys.dm_io_virtual_file_stats() would be a...

Have you tried the perfmon counter.

SQL Server:General Statistics >> User Connections

Thanks for the reply, so you saying that 0.5 x number of cores would be beneficial or is it more like 0.25 x no of cores ?

I guess one would...

Yes it did, SQL level = 100 and it can find the cpu and memory information.

I am using GUI, I have already done that and its still showing the old log entries from 2 weeks ago, if I check error log file manually I can...

Thats one...

Lowell (10/21/2009)

---

why not use a windows group that has admin rights? you give them a network login, set the password to expire in three days or whatever, and you are...

Maybe I'm not explaining myself properly, all I really want is for a way to audit the administrative login that may be used by support staff, they know what the...

From what I recall, the secondary db is a read only copy and it cannot be altered whilst in log shipping, you will have to stop log shipping and reconfigure...

It all makes sense now, didnt realise thats what you meant. How about applications that run in the form of exe's, application.exe <dbserver> <username> <password>

Thanks very much.

Thanks for informing me about that, how about non .NET applications.

Also, If for example I grant permissions to a single SQL login that an...