Play eh ? Well, now I am going to tease you a bit Kevin ...

There is not just one, but 4 Active/Passive clusters and 2 Single node clusters - each...

alter database your_database_name set restricted_user

is kind of essential in our environment. it keeps out application servers and web servers that can actually jump in between the

alter database your_database_name set...

EMC should be able to provide you with some information as well. Theoretical IOPs per second and MB (or GB) per second throughput for the entire SAN for starters.

Also, they...

A few questions ...

What version of Windows Server ?

What type of SAN are you using ?

Are you using any LUN presentation software such as Veritas Volume Manager ?

Have you run...

how about this for your restore:

alter database your_database_name set single_user with rollback immediate

go

alter database your_database_name set restricted_user

go

restore database your_database_name

go

alter database your_database_name set multi_user

go

It has actually gotten even worse in one respect - in SQL 2008 R2, and probably 2012, they locked out the ability to clear the tempdb transaction log !!!

I believe that the answer is no. As I understand it any changes at that level involve rebuilding the SQL Server cluster. To be sure I would contact Microsoft for...

Check out this thread and my post at the end ...

http://www.sqlservercentral.com/Forums/Topic544573-146-2.aspx

Some 'practical' experience in this particular subject says:

- no more than 8 files

definitely no more than 1 file per socket as opposed to CPU

- identical...

This is a somewhat 'known' issue with the tempdb transaction log. By default the system does not truncate the completed transactions in the tempdb transaction log until it hits 70%...

We are presently going through the addition of a new domain and the re-domain-ing of SQL Servers. Microsoft's advice in our case was for cluster rebuilds (whether they were Windows...

I overlooked the links Jack - I understand.

Our site is in the circumstance where we absolutely need it for a few key applications.

Trace flag 1118 is still needed in order to distribute the load on the allocation maps of the tempdb otherwise all of that activity is in the first data file....

Are you using SQL startup trace flag 1118 ?

If you are not then the additional data files for tempdb are not really buying you any performance improvements.

If you are using...

for non-sysadins you'll need one more configuration step:

--------------------------------------------------------------------------------

--- grant access to the profile to the DBMailUsers role

--- (this is only needed for non-sysadmins)

--------------------------------------------------------------------------------

exec msdb.dbo.sysmail_add_principalprofile_sp

...