You can use the Profiler GUI to playback a trace against a server. But, it's single threaded, so you're not going to be able to scale it up much. SQL...

You sort of can't. Not really. There's no way to break down memory, cpu or I/O by database in that manner.

However, what you can do is capture the query metrics,...

Mainly if it does what it says on the box. I've got a chapter in there, but I haven't seen all the other chapters. I'm curious how the team did....

Like it says in the article:

To use sys.dm_os_buffers as part of a monitoring process, you just have to look for the two events, RESOURCE_MEMPHYSICAL_LOW or RESOURCE_MEMVIRTUAL_LOW. These are available in...

The amount of space used by the database isn't determinative of the log size. It's the transactions that come through. You can have a gigantic database, but a very small...

I've got a detailed blog post on what's going on here[/url]. As noted, you need to backup the log file. You can change the database to simple recovery and...

If the optimizer still thinks, based on statistics, a different index is more selective than your filtered index, that would explain why it's being selected. I can't say beyond that...

Yeah, we're comparing apples to hammers to a degree. If there are varying loads on the servers, other differing executables, etc., then you can't really compare resource usage between them.

So, how's the material? You're reviewing more of the rough & ready aspect of getting the alpha, which is cool, but I'm curious how we did on the meat.

For those interested, it's worth mentioning that Red Gate SQL Backup[/url] has an automation routine built into the newest release that makes backup testing a lot easier. It will do...

It does depend on how you defined "used". You could also take a look at the index usage statistics to see how often a clustered index (which is a table)...

You can check the ring buffers for one of three different error messages, Out of Memory messages, Low Physical memory or Low Virtual memory. You can also use the DBCC...

It's a giant topic. But, as with everything else SQL Server, start with the Books Online. Microsoft Developers Network (MSDN) also has an example of a plan. And finally you...

It's limited based on the available memory.

But why would you be nesting IF/ELSE statements to the limit of your memory capacity? It strikes me that you might be going down...

Creating a clustered index is generally considered to be part of the work of designing a database. Who designs a database? There's no absolute, hard and fast rule on that....