How much latency are you entitled?  Log shipping comes to mind as well.   What bums me out is that I am starting to see more and more of this transactionally...

I have found that on large systems that setting the max degree of parallelism to 1 can improve the overall performance of the system.  This was done on our SAP system...

I do not know... I wasn't even sure that the affinity mask would work for you.  I have not worked with it and do not know a lot about it's...

Eric, take a look at the affinity mask Option settings.  

:blinkkay..what was this??

Without impacting the production database?   It's on the same server...

Thanks for the input.  I will give it a try 🙂

Allen...........It's the EXACT same story here.  In fact I will share your post with my Basis Admin.  

I asked Tom (see Basis Admin) to contact SAP regarding the cost threshold. ...

Okay, I admit it...I'm bored today...

sp_addrole  @rolename  =  'DevRole',

            @ownername =  'dbo'

GO

--

GRANT CREATE TABLE     TO DevRole

--

GRANT CREATE PROCEDURE TO DevRole

--

GRANT CREATE VIEW      TO DevRole

--

--GRANT ETC.....

You'll need a role in each database.  You may want to create it in model so all of the new db's get it.

Script out the CREATE ROLE and GRANT <PRIV>...

That's interesting Dan.   I am kind of wondering what the state of the sysindexes table is.   Is the FirstIAM value out of whack??  That probably isn't the problem.  I am kind...

First thing Jason, take away the dbo privileges unless if you want them to have free roam of the database.

Yes you can imitate the behavior of Oracle.  This is a...

* Clean up old/unused statistics

* Verify last statistics update; recommend updates

* Suggest tables that should be pinned

* Check for startup procedures

* Check for 'fake' user tables

* Possibly clean up...

This would be a good thing to make a list for.   Here are some quick thoughts.

1. Orphaned records (Yes, it can happen)

2. Uncommited transactions

3. Like your #2, but also in...

Trace yourself in profiler while you look at the jobs.. That should give you an idea of the permissions you need.   Without testing anything I am guess readonly permissions in...