That is rather odd, because I can find the deadlock event searching through the file target for the system health session.

Lowell, I did try your change and it made...

TJT (12/3/2014)

---

There has been a lot of great feedback to my questions and I have a few more questions:

Would you recommend splitting TempDB into multiples files equal to the number...

Shared feature directory should not be changed from default, those are just the management tools and clients. The instance root directory is what you would set to your app drive...

TJT (12/1/2014)

---

Thanks Shawn.

I was wondering also how you would allocate space for each drive. Let's say there is 1 TB space available and you have 40 or 50 Gig...

Traces are logged within the default trace if that happens to be enabled on your instance. You can use the script below to pull out the application name of the...

I am looking for advice on installing SQL Server 2012 on a VM. Let's say you have 8 cores and 1.5 TB of drive space and 16 Gigs of RAM....

You let SQL Server do that for you, meaning you don't necessarily control 8GB goes to db1, and the rest is split between db2 and db3.

SQL Server is going...

It should be based on the business rules and security standards required in your environment. When I contracted with the military, absolutely no developer login could be found in production.

In...

You should include created date if you are going to try and pull it from those queries above. Unless you specify that your developers are altering procedures, it is a...

What you are referring to I believe would be done through source control. Unless you are already tracking object level changes in your database there is no information natively captured...

What "sp's" are you talking about?

If corruption is found the SQL Agent job will show a failure for that database.

I will throw in that asking that question likely means you need to read through the stairway series on AlwaysOn[/url].

This is likely something with using SSMS, that is the only thing .NET 3.5 SP1 is required for with SQL Server.

It is actually a Windows Feature on the server or...

I am not sure what the actual question is here but if you are referring to David Klee's presentation you can re-watch it on PassTV here.

The main point I think...