ssinger-815504 (5/20/2014)

---

We run a Java application on SQL Server. We are load testing on this machine:

HP DL380 G8 duel E5-2650 CPU

16 CPU Hyperthreaded to 32 cores

32GB Memory

Dedicated san...

Thanks, I will look into that tool.

I have MAXDOP set at 8 right now. From the research I've done, that is a good setting for the amount of cores...

You can also do server\instance,port

like

SQL01\TestInst,55001

If the path is staying the same, I can't think of a reason why a detach would be needed.

Start with the highest level and work down.

SQLQuest29 (1/23/2013)

---

sqlfriends (1/22/2013)

---

It sounds to exclude it from full backup is a good idea, and do a full backup whenever there is a change.

One thing I need to change though,...

GilaMonster (12/21/2012)

---

MyDoggieJessie (12/21/2012)

---

For instance, high PAGEIOLATCH_EX "may" indicate issues with the disk subsystem (hardware) because it's waiting to look up the page from the disk, CXPACKETS may indicate poorly written...

Steve Jones - SSC Editor (12/21/2012)

---

Monitor is built to monitor and alert. That's it's focus. Some of the other products are more for digging in and troubleshooting. It depends on...

Thanks guys! I've done some more research and Redgate's SQL Monitor might be what I'm looking for. I'm surprised no one recommended it though, so I'm a bit...

Are you setting it up as asynchronous(high-performance)?

Ninja's_RGR'us (8/7/2011)

---

I know this is an old thread but since it seems to be found often on google, I find it important to tell anybody reading this that our collective...

subramani.rudrappa 78855 (11/16/2012)

---

Hey Hi,

I know we can use SSIS to get data from excel and load in to SQL table from where i can achieve requirements.

I thought of using only...

Perry Whittle (11/16/2012)

---

the stripe size specifically, the optimal stripe sizes for SQL Server are 64KB and 256KB.

As i mentioned above you need to vary your tests as data files are...

robr-793239 (11/14/2012)

---

However, in our production system, the TempDb is on the same volume as the PRIMARY File Group. My current tack will be to try to separate those two and...

Ah, interesting. I knew that is how our's was, didn't...