louislamour2673 (9/25/2014)

---

As you noted, using that counter only tracks transactions with "read committed snapshot isolation level." Does anyone know of a way to monitor and alert on ANY long...

Just minor note but it appears one of your images did not take, your first "alert" image is repeated when "Select Transactions as the Object and set the Counter to...

I have done this at a program office with the Air Force where the business analyst wanted data out of the database in order to manipulate it in Excel for...

alex_pixley (9/24/2014)

---

Shawn,

Thanks for the reply. I was looking for something simple that could be run on demand. If SSRS can't do what I've described, I'd rather build an...

I would look at having a central database (support or management type) that contains this type of information.

Example:

- Create a management database on the instance your SSRS is configured...

You need to figure out what is blocking the command. You can use the system_health session in SQL Server 2008 to pull the deadlock XML[/url].

From there you have to determine...

rajeshdba83 (9/22/2014)

---

Thanks for your reply, I have asked customer to grant execute permission on sp_readerrorlog, but then they came back and said that is working s they are not able...

In order to use the Log File Viewer in SSMS the login requires membership in the securityadmin role. Which this role is to be treated the same as sysadmin role,...

Yes. They will be offline index rebuilds, meaning that changes to the index/table could be blocked during the operation.

can we create a...

I'm not sure if you need all the columns returned from that procedure but you can get job activity for an instance by querying msdb.dbo.sysjobactivity.

Brandie Tarvin (9/19/2014)

---

Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly granting that...

I generally read most anything Glenn Berry writes on hardware specific to SQL Server. Latest article on sqlperformance.com is a good read on processors.

You can also get his book for...

Alerts for severity of 10-16 are not capable of having it log more information.

Your option would be to use Extended Event session or Profiler. I believe Extended Event would be...

bartedgerton (9/17/2014)[/bI think I may open a ticket with Microsoft on this. I just wanted to see if anyone was aware of any database specific setting that would effectively...

SSMS > Help > About, are you still running the RTM version of SSMS or is it patched?

Intellisense is a thing that always will cause problems, and never has an...