SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Performance Rss

   Items 1 to 20 of 117    Older >>
 

Batch Mode For Row Store: What Does It Help With?

Considering SQL Server 2019? Erik tells you what kinds of queries will get the biggest performance improvements.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,391 reads

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2018/06/29 (first published: 2016/02/10) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 4,377 reads

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.  Read more...
By Additional Articles 2018/06/26 | Source: Microsoft MSDN | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 2,874 reads

Index Utilization Summary Report Script

Index Report Scripts ...  Read more...
By Yusuf Kahveci 2018/06/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,565 reads

SQL Server WaitStats Script

WaitStats Find Script...  Read more...
By Yusuf Kahveci 2018/06/12 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,594 reads

Statistics not updated for the last 30 days

Find out-of-date statistics for 30 days  Read more...
By Yusuf Kahveci 2018/06/11 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 2,135 reads

SQL Server All View Refresh

SQL Server All View Refresh Scripts  Read more...
By Yusuf Kahveci 2018/06/05 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,975 reads

SQL Server Long Query Script

SQL Server Long Query Find Script   Read more...
By Yusuf Kahveci 2018/05/30 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,990 reads

Monitor Query Performance Using Query Store in SQL Server

The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.  Read more...
By Additional Articles 2018/04/12 | Source: Database Journal | Category: query performance
Rating:  Rate this |   Briefcase | 4,114 reads

Small Changes and Big Impacts

Using new features and changing code can cause problems in your environment. Always test to be sure that the impact is acceptable.  Read more...
By Steve Jones 2018/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count

Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use.  Read more...
By Additional Articles 2018/03/26 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 2,979 reads

Balancing Performance and Readability

Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.  Read more...
By Gary Pollock 2018/03/20 | Source: SQLServerCentral.com | Category: coding style
Rating: |  Discuss |   Briefcase | 771 reads

SQL Server Missing Index

SQL Server Missing Index Detail Script  Read more...
By Yusuf Kahveci 2018/02/28 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 2,570 reads

JSON performance

By Evgeny Garaev 2018/02/26 | Category: json
Rating: (not yet rated) |  Discuss |   Briefcase | 721 reads

"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.  Read more...
By Additional Articles 2018/02/23 | Source: Brent Ozar Unlimited Blog | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 6,713 reads

Index Fill Factor

By Mohammed Arshad 2018/02/06 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 926 reads

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 865 reads

Get Index Scan Count

Script to get the index scan count and Average Fragmentation(since last restart)  Read more...
By Mohammed Arshad 2018/01/10 | Source: SQLServerCentral.com | Category: indices
Rating: |  Discuss |   Briefcase | 353 reads

We Need DevOps for Performance

CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.  Read more...
By Steve Jones 2017/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.  Read more...
By Additional Articles 2017/11/02 | Source: SimpleTalk | Category: performance
Rating:  Rate this |   Briefcase | 7,067 reads
   Items 1 to 20 of 117    Older >>
 
Tags
indexing (10)    
t-sql (10)    
blogs (8)    
tuning (8)    
editorial (7)    
execution plans (7)    
administration (5)    
sql server 2014 (3)    
cardinality estimates (2)    
comparison (2)    
hash match (2)    
healthcheck (2)    
merge (2)    
optimization (2)    
query optimizer (2)    
sql (2)    
sql server 2016 (2)    
sql trace (2)    
statistics (data) (2)    
trace flags (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
agent jobs (1)    
async_network_io (1)    
azure (1)    
backup (1)    
batch mode (1)    
best practices (1)    
binary flags (1)    
binding (1)    
bit operations (1)    
bottle necks (1)    
bottlenck (1)    
cardinality estimator (1)    
coding style (1)    
compression (1)    
computed columns (1)    
conditional split (1)    
consolidation (1)    
counter (1)    
cpu (1)    
cpu usage data (1)    
cursors (1)    
cxpacket (1)    
data mining (1)    
database (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
dateadd (1)    
debug (1)    
deleted (1)    
devops (1)    
disk encryption (1)    
distinct (1)    
dm_exec_query_stats (1)    
dm_exec_sql_text (1)    
dm_os_performance_counters (1)    
dmvs (1)    
duplicates (1)    
effective dates (1)    
encryption (1)    
estimated plan (1)    
exec (1)    
fillfactor (1)    
foreign keys (fk) (1)    
fragmentation (1)    
friday poll (1)    
group by (1)    
hardware (1)    
hekaton (1)    
high cpu (1)    
i/o performance (1)    
identity property (1)    
indices (1)    
in-line memory (1)    
in-memory (1)    
inserted (1)    
instant file initialization (ifi) (1)    
integration services (ssis) (1)    
io (1)    
jdbc (1)    
json (1)    
lag (1)    
lead (1)    
linux (1)    
load balancing (1)    
lock (1)    
long query (1)    
lookup table (1)    
machine learning (ml) (1)    
maintenance (1)    
max_elapsed_time (1)    
memory etc... (1)    
microsoft sql server (1)    
migration (1)    
missing index (1)    
monitoring (1)    
network (1)    
nvarchar (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page split (1)    
page splits (1)    
parallelism (1)    
pass summit (1)    
performance and tuning (1)    
query (1)    
query data store (qds) (1)    
query optimization (1)    
query performance (1)    
r language (1)    
r statistics (1)    
rcte (1)    
read committed snapshot isolation (1)    
readability (1)    
referential integrity (1)    
refresh view (1)    
report (1)    
reporting services (ssrs) (1)    
row store indexes (1)    
schedule (1)    
scope_identity (1)    
set-based loop (1)    
software development (1)    
sparse columns (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sql server 2019 (1)    
sqlagent (1)    
sqlh2 (1)    
sqlio (1)    
sqlpass (1)    
sqlprep (1)    
sqlserver (1)    
sqlserver2008r2 (1)    
sqlturkiye (1)    
statistics (1)    
string_split() (1)    
sys.objects (1)    
tally table (1)    
tips (1)    
tools (1)    
truncate (1)    
tune (1)    
union all (1)    
update (1)    
upgrading (1)    
varchar (1)    
video (1)    
view (1)    
vnext (1)    
wait events (1)    
wait stats (1)