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

Content with tag Performance Rss

   Items 1 to 20 of 107    Older >>
 

SQL Server WaitStats Script

WaitStats Find Script...  Read more...
By Yusuf Kahveci 2018/01/18 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,272 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 | 693 reads

Index Utilization Summary Report Script

Index Report Scripts ...  Read more...
By Yusuf Kahveci 2018/01/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 1,215 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 | 242 reads

Find Most Expensive View (By Execution Count)

SQL Server View Execute Count Script ..  Read more...
By Yusuf Kahveci 2018/01/09 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,257 reads

SQL Server High CPU Find Query

SQL Server High CPU TOP 200 Query  Read more...
By Yusuf Kahveci 2018/01/05 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,504 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 | 42 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 | 5,262 reads

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...
By Paul Brewer 2017/10/19 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 785 reads

WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed.  Read more...
By Kenneth Igiri 2017/10/10 | Source: SQLServerCentral.com | Category: wait events
Rating: |  Discuss |   Briefcase | 847 reads

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.  Read more...
By Additional Articles 2017/09/20 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,801 reads

Five Mistakes Performance Tuners Make

Erik Darling explains why your queries aren't scaling in production.  Read more...
By Additional Articles 2017/09/06 | Source: Brent Ozar Unlimited Blog | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,970 reads

Performance Myths : Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/08/02 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 6,668 reads

Performance Myths: Oversizing string columns

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...
By Additional Articles 2017/07/13 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 6,627 reads

Performance of OBJECT_NAME() & Co.

By Thomas Franz 2017/07/10 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 855 reads

Properly Persisted Computed Columns

Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.  Read more...
By Additional Articles 2017/06/20 | Source: SQLPerformance.com | Category: trace flags
Rating: (not yet rated)  Rate this |   Briefcase | 4,409 reads

UNION ALL Optimization

Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.  Read more...
By Additional Articles 2017/06/13 | Source: SQLPerformance.com | Category: union all
Rating: (not yet rated)  Rate this |   Briefcase | 5,651 reads

Performance Myths : Truncate Can't Be Rolled Back

Derik Hammer sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.  Read more...
By Additional Articles 2017/06/01 | Source: SQLPerformance.com | Category: performance
Rating:  Rate this |   Briefcase | 4,378 reads

Combining R and SQL Server to diagnose performance bottlenecks

Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.  Read more...
By Nick Burns 2017/05/29 (first published: 2015/12/07) | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 9,125 reads

Performance Myths: Table variables are always in-memory

Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.  Read more...
By Additional Articles 2017/05/11 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,457 reads
   Items 1 to 20 of 107    Older >>
 
Tags
t-sql (10)    
blogs (8)    
execution plans (7)    
indexing (7)    
tuning (7)    
editorial (6)    
administration (5)    
sql server 2014 (3)    
cardinality estimates (2)    
comparison (2)    
fragmentation (2)    
hash match (2)    
healthcheck (2)    
high cpu (2)    
index (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)    
best practices (1)    
binary flags (1)    
binding (1)    
bit operations (1)    
bottle necks (1)    
bottlenck (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_db_index_usage_stats (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)    
friday poll (1)    
group by (1)    
hardware (1)    
hekaton (1)    
i/o performance (1)    
identity property (1)    
index detail (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)    
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)    
network (1)    
nvarchar (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page split (1)    
page splits (1)    
parallelism (1)    
performance and tuning (1)    
query (1)    
query optimization (1)    
r language (1)    
r statistics (1)    
rcte (1)    
referential integrity (1)    
refresh view (1)    
report (1)    
reporting services (ssrs) (1)    
schedule (1)    
scope_identity (1)    
set-based loop (1)    
software development (1)    
sparse columns (1)    
sql server 2005 (1)    
sql server 2012 (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)    
upgrade (1)    
varchar (1)    
view (1)    
vnext (1)    
wait events (1)    
wait stats (1)