With changing the recovery model to Simple you've broken the backup chain.

This performance counters poster is still pretty excellent.

http://www.quest.com/backstage/images/promotions/SQLServer-Perfmonance-Poster.pdf

You can additionally use the OS performance monitor (perfmon.exe) to obtain the counters' values and make a comparison, in order to conclude...

Grace09 (11/19/2013)

---

You can use this link http://blogs.msdn.com/b/mvpawardprogram/archive/2012/06/04/using-sys-dm-os-ring-buffers-to-diagnose-memory-issues-in-sql-server.aspx

As you can see you can only see some info that you can see at other places on your system as well. However it's...

Grace09 (11/19/2013)

---

here is the result from the query, How should I interpret it? Thanks.

NodePageLifePageLife_SBufferPool_PagesBufferPool_MiBBufferPool_MiB_S

12:08:19436995359046 41867.547...

For IO bottlenecks you need sys.dm_io_virtual_file_stats and sys.dm_io_pending_io_requests

For Memory pressure you can use sys.dm_os_buffer_descriptors, sys.dm_os_performance_counters and others.

The full grouped list of the dynamic views is here http://technet.microsoft.com/en-us/library/ms188754.aspx

For e.g. you can...

A good start is a book. On this site you have some books: http://www.sqlservercentral.com/Books/

One really good is

"Troubleshooting SQL Server

A Guide for the Accidental DBA

Jonathan Kehayias and Ted Krueger"

Regards

IgorMi

You can also install a separate named instance of sql server 2012,...

The same way as you do it on sql server 2008 r2.

Lowell (11/19/2013)

---

d.velders (11/19/2013)

---

It's indead an idea to generate a SP that does the calculation of these working days.

Does anyone have an example on how to do this or even better...

What do you mean by stress more concretely?

It can be anything from IO bottlenecks, high CPU utilization, Memory issues (memory pressure) , blocking and deadlocking ...

Hi

I found this in my repository

select 'TO', 'Object name' = (s6.name+ '.' + o1.name),

[Type] = substring(v2.name, 5, 16),

[Updated] = substring(u4.name,...

Shrinking DB is different from Shrinking a File. You could have shrunk only the log file.

Shrink usually introduces a lot of fragmentation.

You're lucky...

Koen Verbeeck (11/19/2013)

---

Good point.

It might be easier to create a stored procedure that checks if the job should run...

What about when one of those day is a public/national holiday?

Hi,

You have duplicate rows and you cannot do a correct update.

Ok,

You can introduce a row id column (i.e. id with identity property), and then you'll have a better control over...