Eirikur Eiriksson (9/23/2015)

---

JaybeeSQL (9/23/2015)

---

Eirikur Eiriksson (9/22/2015)

---

Have a look at this blog post: Microsoft SQL Server Licensing...

Already seen...

Hi all,

Management want this tested - don't ask why, there's no gain except getting a baseline - but it's a Profiler trace, pre-and-post disk additions.

Gila recently suggested...

GilaMonster (8/27/2015)

---

To be honest, other than TempDB, I'd probably leave the others alone for now. Moving master is not...

GilaMonster (8/26/2015)

---

That would be a far better question, because there's no SQL command to add drives to a server. 😉

Firstly, you don't want to move the binaries, as that would...

We're adding drives to the database server. 🙂

A better question is, "What is the best procedure to move database system and user...

GilaMonster (8/9/2015)

---

No, you don't need everything, however replay requires a very specific set of events and columns. Use the T-SQL Replay template and don't change anything after

eg you need the...

Hold it people I just had a thought (can't believe I'm so pathetic to think of such things on a Sunday morning LOL!)...

As the purpose of the replay will be...

GilaMonster (8/6/2015)

---

Grant, who works for Redgate, recommends distributed replay. 🙂

Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use...

Dupe

Hee-hee!!

Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use...

GilaMonster (8/6/2015)

---

Yes, you can use multiple controllers (from multiple client machines) to scale the workload up. You can use the Stress option of distributed replay...

GilaMonster (8/5/2015)

---

It's not usually a linear progression. I did a scale-up test for a client last year. As load increased, the CPU increased linearly up to about 2.5x base load,...

Distributed Relay isn't available on 2k8 I'm advocating a move to 2012 or possibly 2014, but I want to capacity-plan this BEFORE we spend our budgets (which are big,...

GilaMonster (8/3/2015)

---

Well, yes. It'll be a stock, standard CREATE TABLE statement. As I said, you can't create the table from the execution of the procedure. You'll need to create the...