Monitoring

Under the ORM Hood: Revealing the SQL

  • Article

Your application code may look neat and clean, and you are using a sound Object-relational Mapper, but when you put the pedal to the metal, you're not getting the performance. The time has come to lift the hood and see what SQL is being generated by the ORM, and what part of your code is causing the bottlenecks. The effect can be spectacular.

2010-11-05

3,304 reads

Database Activity Monitoring Part 1 - An Introduction

  • Article

We are inundated with new technologies and products designed to help make our organisations safe from hackers and other malcontents. One technology that has gained ground over the past few years is database activity monitoring. It makes sense to protect valuable databases, and by adding an intelligent monitor capable of sniffing out threats an additional level of protection can be gained.

But what is database activity monitoring and why should you care?

2010-03-08

4,755 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

sqlcmd

By sqlfriend

I found recently sqlcmd is missing on my computer. It used to be there....

Multi-column pivot table help

By Pete Bishop

I have the following data in [table_1]: last_updated type_desc size_bytes used_bytes 2019-05-23 LOG 1835008...

Task Scheduler Job set up for Sql Server Agent

By pdsqsql

Hello, I am trying setup automatic job using the windows task scheduler to notify...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers