Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Performance Tuning Rss

   Items 1 to 20 of 561    Older >>
 

Custom Solution to Measure SQL Server Query Performance Improvements

Performance tuning is a creative process which requires a lot of attention and manual work. SQL Server 2016's Query Store makes some of this work much easier, but what if you're using an earlier version? Fikrat Azizov shows how to automate assessing SQL Server query performance changes by using custom performance collection tools and reports.  Read more...
By Additional Articles 2016/06/23 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 3,615 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 68,306 reads

Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables

Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.  Read more...
By Additional Articles 2016/04/25 | Source: SQLPerformance.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 5,385 reads

Getting Started Tuning Performance in Azure SQL Database

Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.  Read more...
By Additional Articles 2016/04/20 | Source: SQLPerformance.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,436 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 68,306 reads

Find Currently Running Query – T-SQL

Following script retrieves the queries currently executing on the server.  Read more...
By Sri Kurra 2016/02/29 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,134 reads

Show running queries

Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.  Read more...
By Richard Swinbank 2016/01/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 4,268 reads

Know read and write ratio before you tune database performance

A script to get the user table query ratio and update radio,etc  Read more...
By Michael Zhang 2015/12/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,528 reads

Finding Queries to Tune

A query to help identify queries that need some tuning.  Read more...
By Simon Osborne 2015/10/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,435 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators  Read more...
By Monte Kottman 2015/09/22 | Source: SQLServerCentral.com | Category: kpi
Rating: |  Discuss |   Briefcase | 4,337 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 68,306 reads

Searching for Plans

Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.  Read more...
By Steve Jones 2015/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 245 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 68,306 reads

Show running queries

Identify the current statement and its line number within a running batch. Includes a link to the execution plan, if available.  Read more...
By Richard Swinbank 2016/01/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 4,268 reads

Index usage overview

This view reports almost everything you want to know about your indexes  Read more...
By Wilfred van Dijk 2015/02/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,842 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 68,306 reads

The Rich Rewards of Tuning SQL

The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.  Read more...
By Tony Davis 2014/12/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 518 reads

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to interesting discoveries and solutions.  Read more...
By Viktor Gorodnichenko 2014/12/11 | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 7,094 reads

Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler

In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.   Read more...
By Press Release 2014/12/05 | Source: Redgate | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 7,278 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2016/05/25 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 68,306 reads
   Items 1 to 20 of 561    Older >>
 
Tags
sql server 7 (121)    
t-sql (113)    
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)    
execution plans (7)    
strategies (7)    
database weekly (6)    
xml (6)    
backup and 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)    
webinar (4)    
.net (3)    
analysis services (ssas) (3)    
availability (3)    
cpu (3)    
datatypes (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)    
architecture (2)    
blocking (2)    
computed columns (2)    
cursors (2)    
data warehousing (2)    
deadlocks (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)    
temporary tables (2)    
tools (2)    
training (2)    
triggers (2)    
tuning (2)    
address windowing extensions (1)    
affinity (1)    
algorithm (1)    
asp (1)    
auditing (1)    
awe (1)    
azure (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 index (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 performance analyzer (1)    
database snapshots (1)    
datetimefromparts (1)    
dbcc checkdb (1)    
dmo (1)    
dmvs (1)    
dmv's (1)    
dpa (1)    
duplicate indexes (1)    
ebook (1)    
edit distance (1)    
editorial - mp3 (1)    
english query (1)    
excel (1)    
extended events (1)    
fetch (1)    
fnord (1)    
formatting (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)    
implicit conversion (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)    
online re-indexing (1)    
optimization (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 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)    
solarwinds (1)    
sp writing tips (1)    
sp_blitz (1)    
sql puzzles (1)    
sql server agent (1)    
sql trace (1)    
sqlite (1)    
star schemas (1)    
stored procedure (1)    
string (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 scan (1)    
tables (1)    
tempdb (1)    
test data (1)    
tips and tricks (1)    
top cpu queries (1)    
total latch wait time (1)    
trace (1)    
transaction log (1)    
transactions (1)    
tvp (1)    
udt (1)    
update (1)    
update statistics (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)