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 41 to 60 of 537    Older >>
 

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,141 reads

Find out which SQL Server instance is consuming most of the CPU

We have a number of SQL Server hosts with multiple SQL Server instances. From time to time we have CPU issues, but we are not sure which instance is causing the issue. How do you find which SQL Server instance is causing CPU pressure on machine with multiple SQL Server instances? Check out this tip for ideas on how to find the correct SQL Server instance which is causing CPU pressure.  Read more...
By Additional Articles 2012/09/26 | Source: MSSQLTips.com
Rating:  Rate this |   Briefcase | 2,388 reads

Fuzzy-String Search: Find misspelled information with T-SQL

An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008  Read more...
By Thomas Keller 2014/01/10 (first published: 2012/09/18) | Source: SQLServerCentral.com | Category: fuzzy match
Rating: |  Discuss |   Briefcase | 23,475 reads

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.  Read more...
By Ian Stirk 2012/08/03 (first published: 2009/09/17) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 41,976 reads

Performance Data

Great DBAs collect all kinds of metrics on their instances and let them manage themselves. However many administrators need help monitoring and interpreting the data. Today Steve Jones asks if you think this data needs extra security or is it less of an issue than other PII data.  Read more...
By Steve Jones 2012/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 343 reads

Single User Performance of SQLite v. SQL Server

A look at the performance of SQL Server compared to SQLite for single user applications.  Read more...
By Timothy A Wiseman 2012/07/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,204 reads

Issue with Current Merge Join algorithm and ways to Improve it

This will show you the issue with current Merge join algorithm and a workaround for this and thus improving the performance of Merge joins  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 1,057 reads

SQL Server : Parameter Sniffing

Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....  Read more...
By 2012/06/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,909 reads

Get Performance Tips Directly From SQL Server

This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.  Read more...
By Ian Stirk 2012/06/22 (first published: 2009/06/11) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 46,449 reads

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2012/06/19 | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 3,955 reads

SQL Server Prefetch and Query Performance

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning.   Read more...
By Additional Articles 2012/06/14 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 3,680 reads

ETL Performance Auditing - Part 2: Auditing Data Staging Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2012/06/12 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 4,989 reads

Use your own optimizer to tune queries

Use your own optimizer to tune queries  Read more...
By Gulli Meel 2012/06/07 | Source: SQLServerCentral.com | Category: custome statistics
Rating: |  Discuss |   Briefcase | 2,739 reads

Re-compilation and Its effects on Performance

How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?   Read more...
By at yazdani 2012/06/07 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,094 reads

The Real World: Implementing AWE

Describes the gains experienced in my environment by impleenting AWE.  Read more...
Rating: |  Discuss |   Briefcase | 7,932 reads

Which SELECT * Is Better?

The short answer is, of course, none of them, but testing is the only way to be sure. I was asked,...  Read more...
By 2012/05/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,338 reads

Performance Test of New Date Manipulation Functions (SQL Spackle)

Performance test of new SQL 2012 functions DateTimeFromParts and Format  Read more...
By Wayne Sheffield 2012/05/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,896 reads

The Clonesome Database

You need a quiet couple of hours poking about with DMVs, and checking execution plans to get to the bottom of the a query issue, but you can't make a copy the production database either. It's too big, and the data is private....  Read more...
By Phil Factor 2012/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 197 reads

ROWLOCK Escalation

By Chris Fradenburg 2012/03/19 | Category: table hint
Rating: (not yet rated) |  Discuss |   Briefcase | 2,264 reads

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,552 reads
<< Newer    Items 41 to 60 of 537    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)    
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)    
data types (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 columns (2)    
cursors (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 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 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)    
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)    
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 (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)    
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 partitioning (1)    
table scan (1)    
tables (1)    
tempdb (1)    
temporary tables (1)    
test data (1)    
tips and tricks (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)