I apologize I didn't put the physical structure in my post.

The SAN is a set of 8 SAS and 8 SATA drives, 2 controllers, not sure how much RAM anymore...

SQLIO is a good idea - don't know why I hadn't thought of that. It will be odd to see if it better!

Thanks for your replies.

We are using Blades on VMWare which is a little different than a LUN but the same in theory. The Blade can have several virtual servers on...

Update usage and Update statistics might help

Can you find the spid assigned to your transaction? select * from sysprocesses or better yet if you are in 2005

SELECT * FROM

(SELECT QS.*,

...

Oh, I'm sorry I should have read that more thoroughly oops!

Sorry I do not have any experience with this option 🙁 I try to use Read Uncommitted to avoid blocking...

Check Paul Randall's site - he has a lot of great posts about Recovery.

http://www.sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

I have my Sharepoint database server configured to only use

EXEC sp_configure 'max degree of parallelism', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'optimize for ad hoc workloads', 1

go

RECONFIGURE

go

This really has helped performance. You might...

Can you kill the offending spid?

I think this is more for a development environment where if you want to rollback to a previous state it is easier to do than perhaps a full restore. At...

Depending on the version of SQL Server you could have your DBAs configure an Alert on their server to send them an email. You have to have a mail profile...

In some cases yes but they have a max size. I use policy to alert if there's less than 2 growths left. On some servers I have plenty of disk...

The login is not displaying correctly... helplogins shows it mapped to the database user. I have closed and reopened SSMS 2005 several times now. 🙁

Never mind - this did NOT work.

I was able to Enable the user, but I still cannot map the login to the db at the server-level.

Help would be GREATLY appreciateD!!

:hehe:

I have a DBA database that I record database sizes in every week and keep for 365 days. I can then look at the statistics from that data and determine...