Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag performance tuning Rss

<< Newer    Items 61 to 80 of 533    Older >>
 

Database Performance Transparency

Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.  Read more...
By Ron Johnson 2012/02/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,755 reads

A Computed Column Defined with a User-Defined Function Might Impact Query Performance

A benefit of using computed columns is that they can save developers from having to write calculation logic at the application layer; at the table level, the application can simply reference the computed column. In addition, performance can be improved by persisting a computed column and building an index on it.  Read more...
By Additional Articles 2012/02/03 | Source: SQLCAT | Category: computed column
Rating:  Rate this |   Briefcase | 2,299 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,370 reads

RECONFIGURE can flush the procedure cache

I ran across this KB article the other day, which lists a few ways in which performance is affected by...  Read more...
By 2012/01/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,411 reads

Window Functions in SQL Server: Part 3: Questions of Performance

A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.  Read more...
By Additional Articles 2012/01/17 | Source: SimpleTalk | Category: window functions
Rating:  Rate this |   Briefcase | 3,371 reads

Changes to SQL Server 2012 Execution Plans

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.  Read more...
By Grant Fritchey 2011/12/14 | Source: SQLServerCentral.com | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 5,933 reads

Finding the Source of Your SQL Server Database I/O

There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.  Read more...
By Additional Articles 2011/11/22 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 3,381 reads

Performance Monitoring with Dynamic Management Views

In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.  Read more...
By Ron Johnson 2011/11/17 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,466 reads

Maximizing SQL Server Throughput with RSS Tuning

Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. This post helps you get the most out of the feature.  Read more...
By Additional Articles 2011/10/18 | Source: SQLCAT | Category: rss
Rating:  Rate this |   Briefcase | 2,230 reads

A Performance Troubleshooting Methodology for SQL Server

When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between symptom and disease: The art of troubleshooting is much more the art of discovering, and assembling, the various pieces of the puzzle so that you have a complete understanding of what is going on inside of a server.  Read more...
By Additional Articles 2011/10/10 | Source: SimpleTalk | Category: performance tuning
Rating:  Rate this |   Briefcase | 5,196 reads

How to Performance Tune the Microsoft SQL Server tempdb Database

If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.  Read more...
By Additional Articles 2011/08/31 | Source: SQL Server Performance | Category: tempdb
Rating:  Rate this |   Briefcase | 4,591 reads

Speeding up database access - part 4 Fixing expensive queries

Part 4 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.  Read more...
By mperdeck 2011/08/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,885 reads

A faster DBCC CHECKDB?

This article describes a utility that is able to report the most common DBCC CHECKDB errors significantly faster than DBCC CHECKDB does itself.   Read more...
By Ian Stirk 2011/08/23 | Source: SQLServerCentral.com | Category: dbcc checkdb
Rating: |  Discuss |   Briefcase | 13,678 reads

Automatically Capturing SQL Server Performance Metrics

This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.  Read more...
By Additional Articles 2011/08/09 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 4,220 reads

Speeding Up Database Access Part 3 - Fixing Missing Indexes

Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.  Read more...
By mperdeck 2011/08/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 8,435 reads

CLR Performance Testing

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.  Read more...
By Additional Articles 2011/08/01 | Source: SimpleTalk | Category: sqlclr
Rating:  Rate this |   Briefcase | 2,320 reads

System Monitor (Perfmon) Counters for SQL Server 2005

Capturing performance monitor counters is of great value to understand how SQL Server is behaving at a macro level, that being how overall resources are being used within the engine. Without this data it is difficult to determine where the performance issues are occurring. Capturing the metrics has been traditionally from Performance Monitor either on an ad-hoc basis or setting up a log to capture the values on a predefined basis.  Read more...
By Additional Articles 2011/07/27 | Source: MSSQLTips.com | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,941 reads

Speeding up database access Part 2 - Pinpointing Other Bottlenecks

Part 2 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.  Read more...
By mperdeck 2011/07/26 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 10,202 reads

Speeding up Data Access Part 1 - Missing Indexes

In the first part of this series, learn how to pinpoint missing indexes in your databases.  Read more...
By mperdeck 2011/07/19 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 16,876 reads

Email Long Running SPID Info

This script will email info about the longest running SPID in an HTML formatted table  Read more...
By Deon Benjamin 2011/07/07 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,868 reads
<< Newer    Items 61 to 80 of 533    Older >>
 
Tags
sql server 7 (121)    
t-sql (112)    
sql server 2005 (46)    
administration (45)    
indexing (45)    
blogs (23)    
miscellaneous (22)    
configuring (15)    
programming (15)    
hardware (13)    
stored procedures (13)    
database design (11)    
dmv (11)    
editorial (11)    
maintenance (11)    
monitoring (11)    
sql server 2008 (11)    
utility (11)    
maintenance and management (10)    
sql server 6.5 (9)    
advanced querying (8)    
troubleshooting (8)    
ado (7)    
strategies (7)    
database weekly (6)    
execution plans (6)    
xml (6)    
backup / restore (5)    
list indexes (5)    
pivot (5)    
profiler (5)    
search (5)    
sqlservercentral (5)    
sys.dm_db_partition_stats (5)    
basics (4)    
crosstab (4)    
for xml path (4)    
integration services (ssis) (4)    
leadership (4)    
professional development (4)    
replication (4)    
reporting services (ssrs) (4)    
security (4)    
visual basic 6 (4)    
.net (3)    
analysis services (ssas) (3)    
availability (3)    
cpu (3)    
dts (3)    
foreign keys (fk) (3)    
i/o (3)    
indexed views (3)    
paging (3)    
sql server (3)    
sql server 2012 (3)    
sqlclr (3)    
storage (3)    
storage management (3)    
user defined function (udf) (3)    
webinar (3)    
architecture (2)    
blocking (2)    
computed column (2)    
cursors (2)    
data types (2)    
data warehousing (2)    
deadlock (2)    
distributed queries (2)    
etl (2)    
fundamentals (2)    
fuzzy match (2)    
installation (2)    
io (2)    
lock and connection management (2)    
locking (2)    
memory tuning (2)    
openxml (2)    
pagination (2)    
query plans (2)    
row compression (2)    
sql monitor (2)    
statistics (2)    
sys.dm_exec_query_plan (2)    
sys.dm_exec_requests (2)    
sys.dm_exec_sessions (2)    
sys.dm_exec_sql_text (2)    
tools (2)    
training (2)    
triggers (2)    
tuning (2)    
addressing windows extensions (1)    
affinity (1)    
algorithm (1)    
asp (1)    
auditing (1)    
awe (1)    
batch requests per sec (1)    
batching (1)    
best practices (1)    
bi (1)    
big data (1)    
brad mcgehee (1)    
buffer cache hit ratio (1)    
business intelligence (1)    
cached execution plan (1)    
case studies (1)    
change data capture (cdc) (1)    
clustered (1)    
compression (1)    
confio (1)    
connections (1)    
custom optimizaqtion (1)    
custome statistics (1)    
damerau-levenshtein (1)    
data flow task (1)    
database i/o (1)    
database mirroring (1)    
database snapshots (1)    
datetimefromparts (1)    
dbcc checkdb (1)    
dmo (1)    
dmvs (1)    
dmv's (1)    
duplicate indexes (1)    
ebook (1)    
edit distance (1)    
editorial - mp3 (1)    
english query (1)    
excel (1)    
extended events (1)    
fetch (1)    
fnord (1)    
format (1)    
fuzzy-string (1)    
google (1)    
graphs (1)    
hard disk (1)    
heap (1)    
host bus adapter (1)    
hp eva (1)    
html (1)    
idle (1)    
ignite (1)    
indicators (1)    
internals (1)    
ip addresses (1)    
ipv4 addresses (1)    
isolation levels (1)    
kpi (1)    
large data sets (1)    
latch waits per sec (1)    
like (1)    
linked server (1)    
lock escalation (1)    
lock pages in memory (1)    
lock waits per sec (1)    
logins (1)    
logouts (1)    
loop (1)    
memory (1)    
memory grants (1)    
memory management (1)    
merge join performance merge join alogrithm (1)    
metrics (1)    
missing indexes (1)    
name value pair (1)    
naming standards (1)    
news (1)    
nhibernate (1)    
number of deadlocks per sec (1)    
off-topic (1)    
olap server (1)    
other (1)    
pae (1)    
page life expectancy (1)    
page splits (1)    
parameter sniffing (1)    
parameterized queries (1)    
partition (1)    
partition alignment (1)    
partitioning (1)    
perfmon (1)    
performance metrics (1)    
physical address extensions (1)    
policy based management (pbm) (1)    
procedural programming (1)    
procedure (1)    
procedure cache (1)    
query hint (1)    
query optimization (1)    
query performance (1)    
raid (1)    
resource governor (1)    
reverse (1)    
row_number() (1)    
rss (1)    
san (1)    
sas (1)    
sata (1)    
scale-out (1)    
schedulers (1)    
selectivity (1)    
server side trace (1)    
set based (1)    
shrink database (1)    
sp writing tips (1)    
sp_blitz (1)    
sql puzzles (1)    
sql server agent (1)    
sql trace (1)    
sqlite (1)    
star schemas (1)    
substring (1)    
sys.dm_db_index_usage_stats (1)    
sys.dm_db_missing_index_details (1)    
sys.dm_exec_connections (1)    
sys.dm_exec_cursors (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
sys.dm_tran_session_transactions (1)    
system monitor (1)    
table compression (1)    
table hint (1)    
table hints (1)    
table partitioning (1)    
table scan (1)    
tables (1)    
tempdb (1)    
temporary tables (1)    
test data (1)    
top cpu queries (1)    
total latch wait time (1)    
trace (1)    
transaction logs (1)    
transactions (1)    
tvp (1)    
udt (1)    
update (1)    
updategrams (1)    
vmware (1)    
waits and queues (1)    
what queries are running (1)    
where (1)    
while loop (1)    
window functions (1)    
wmi query (1)    
xevents (1)    
xsl (1)    
your own optimizer (1)