You should contact their support. Red Gate has an excellent support team and I'm sure they would be helpful in checking if their product is causing problems.

I'm currently...

I was using export virtual appliance, then after moving it to another computer, virtualbox would have issues with the file. I didn't explore it past that because vmware worked...

Definitely a worthwhile effort. I am using host only networking and running a handful of vms on a test domain. It's been extremely valuable

I ran into the same issues...

What is a Database Administrator today ...

any IT profressional that:

1. Has the ability to learn, very quickly

2. Needs no modifiers to be chill in the face of certain...

Grant/Jeff

Would you say that using SA as the database owner or jobs account is not a preferred method. Did you make new user accounts for each purpose?

Jeff

Have you run...

I was more thinking about areas of the code where DNS is being used. I've seen cases where older parts of a system were pointed to serverA instead of a...

I use both sqlio and crystal disk mark http://crystalmark.info/software/CrystalDiskMark/index-e.html

I can understand needing to find a min #of iops needed, it seems like most storage sales representatives need this...

dns?

http://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

Jonathan Kehayias says:

Summary: don’t use the value 300 as any kind of Page Life Expectancy threshold. Anyone that continues to recommend doing so is doing you a disservice....

Maybe setting a index rebuild/reorg job that will keep things in order more frequently?

1. Virtual Box or VMware workstation

2. SQL Management Studio (latest)

3. Git

4. SQL Source Control

5. Chrome

6. Pidgin

7. Visual Studio (latest)

8. Dropbox

9. Putty

10. Winscp

Grant,

I read at brentozar.com:

http://www.brentozar.com/blitz/jobs-owned-by-user-accounts/

http://www.brentozar.com/blitz/database-owners/

So would you recommend striving towards not using SA (possibly even renaming/disabling it), and creating new accounts that are least privilege for specific...

Perry Whittle (8/13/2012)

---

george sibbald (7/10/2009)

---

sounds to me like the basic problem is the fact the sql server i/o is shared with i/o from other types of servers. the i/o patterns...

Before and after estimated execution plans with the stats could be helpful for showing immediate benefits (Grant Fitchey has a kick *** book on execution plans...http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2)

Overall impact on...

I've witnessed restore operations take FOREVER due to extremely high VLF counts

Michelle Ufford has a good script for checking the count http://sqlfool.com/2010/06/check-vlf-counts/