Browse by Tags
All Tags » SQL Server » performance ( RSS)
-
|
I have put Business Intelligence into a number of small businesses and these guys typically have one server set a side for BI, so how do you cram the database and the cubes into one box to get the best performance? SQL Server databases and Analysis Services...
|
-
|
Ontem foi anunciada a disponibilidade da versão RTM do SQL Server 2008 ! O SQL Server 2008 traz uma leva de novidades: governança e compressão de dados, suporte para dados geo-espaciais, gerenciamento baseado em políticas, relatórios avançados e serviços...
|
-
|
( RTM = Released to Manufacturing) Yes indeed.. today the newest version of the best database software platform anywhere reached a major milestone. It’s ready! You can read the PressPass announcement here. And here is the official press location...
|
-
|
I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider...
|
-
|
Note: This post assumes reader is familiar with SQL Server 2008 MERGE statement ( refresher ). In recent months I had a few chances to use MERGE statement, and I realized that frequently input data applies only to a “slice” or "window" (could...
|
-
|
I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers...
|
-
|
One of the many great SQL Server resources out there is SQL Server Central , and this article on there, Worst Practices - Not Using Primary Keys and Clustered Indexes , by Andy Warren caught my eye. For the most part he’s absolutely right you’d...
|
-
|
I get more and more questions about SQL Server running in a Virtual machine so here’s 3 FAQs to start with… 1. Is there Support for SQL Server on non Microsoft Virtualization platforms (e.g.VMWare)? The definitive document on the is here Read...
|
-
|
It seems very fashionable to buy in technology these days, and some of you must if anyone is actually writing their own stuff these days. I have met quite a few of the product team and they are real people, Like Boris Baryshnikov who wrote resource governor...
|
-
|
Imagine you work in a library and it’s your turn to put the books away that have just been returned. You have a complete catalogue of where every book should go but it’s not quite right, because someone didn’t notice that the first book...
|
-
|
Three Benchmarks Database performance is much a bit like a major sport, there's a governing body, the Transaction Processing and Performance Council (confusingly abbreviated to TPC) and they set the competition rules and judge the results. Unlike most...
|
-
|
Even if your database server runs on the most powerful hardware available, its performance can be negatively affected by a handful of misbehaving queries. In fact, even one bad query, sometimes called a "runaway query," can cause serious performance issues...
|
-
|
A number of factors can affect CPU utilization on a database server, including compilation and recompilation of SQL statements, multithreaded operations, disk and memory bottlenecks, and ETL activity, among others. You'll want to make sure that the CPU...
|
|
|