If you want monitoring on both SQL Server and Oracle, your choices are limited. Quest software (Dell?) has a tool that can do both. Confio has two tools that each...

Not to mention that adding all those checks into a single transaction increases the time that transaction will run which increases the likelihood of blocking and deadlocks.

Without seeing the queries or the execution plan, everything that follows is just a vague guess.

If you're seeing scans, it means either that you don't have the right indexes in...

Steve Jones - SSC Editor (3/28/2013)

---

Good answer: http://meta.stackoverflow.com/questions/167452/what-are-the-most-effective-ways-to-guide-new-users/167510#167510

I know we don't keep people away, but treating them with respect, somewhat without regards to how snippy they may appear, is something...

ScottPletcher (3/28/2013)

---

Grant Fritchey (3/28/2013)

---

ScottPletcher (3/28/2013)

---

There must be more fragmentation in a history table than a current-data-only table.

For single row lookups, this is not really a performance hit.

But for table scans,...

ScottPletcher (3/28/2013)

---

There must be more fragmentation in a history table than a current-data-only table.

For single row lookups, this is not really a performance hit.

But for table scans, even partial ones,...

Your choices are very limited at present. Until SSAS is included in the Azure stack and until they get the Azure VMs out of beta, your only choice is as...

A few other resources that might prove helpful. You can download the free e-book, Troubleshooting for the Accidental DBA[/url]. It covers a lot of what you're asking about. Also, take...

I worked with a design for several years that allowed for versioned data and queries that ran extremely fast. You just have to make sure that you index the tables...

Define help. This will remove all data from the buffer and force a recompile of all queries. If the data load was...

If restarting the server clears up what's going on, I'm not sure that you're seeing memory problems. I'd suggest hitting the sys.dm_os_ring_buffers[/url] to determine if you're getting out of memory...

And this one too.[/url]

You can use the RESTORE VERIFYONLY command to validate that a backup is available and accessible.

I don't understand what you mean by this: "know what is spend if used it"

Just turn that same query into an INSERT ... SELECT... statement and save the data into a table along with the date and time that you collected the information. Then...

opc.three (3/27/2013)

---

Grant Fritchey (3/27/2013)

---

Actually, if you use extended events you can filter by batch_text in sql_batch_completed or by statement in rpc_completed and then use the like_i_sql_unicode_string to do a...