Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Documentation

SQL CPU Loads?

What kind of actions does consume most of the CPU ?

joins,triggers,inserts...etc ?

where can I find a matrix that shows such as this action consumes this much of CPU ?

Tried Procedural without Analysis>>failed!
Tried OR/M with Custom Business Objects>> failed!
Tried ObjectDatabases with Generic Frameworks>>failed!
REUSE OUT!
Avoid ButterFly Effect >> Keep IT Simple & Stupid
[986 byte] By [erdsah88] at [2008-2-24]
«« Graphics card compatibility issues?
»» SymbolicLinks & UAC & ShellExtensions
# 1
All this depends on your database implementation (indexing strategy, type of queries, table size, table design, etc.). There is no fixed cost for these things.

WesleyB

Visit my SQL Server weblog @ http://dis4ea.blogspot.com

WesleyB at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Documentation...
# 2

Costs are relative to the batch you're running, and change as the Optimizer picks the best way to do things.

Look in Books Online in the Dynamic Management Views (DMVs) for good intel on the cost of each query statement. You can also use several tools in SQL Server Management Studio to show the cost of the statements you're running. For instance, turn on the Execution Plan and you'll get a graphical representation of the entire query. Hover over any icon and you'll see a lot of information about that part of the query, including the cost.

Buck

(if this post is helpful, you can mark the question as "answered")

BuckWoody at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Documentation...
SQL Server
SQL Server Documentation

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified