First time here? Check out the FAQ.

Performance-tuning

Cancel

All Questions

Unanswered Questions

molly commented

We added additional temp data files to match our 8 cores. We were expecting performance improvement after adding the files but instead the jobs are taking longer than before. We always encountered the I/O request on this drive where the temp files reside.

Sep 14, '18 performance-tuning

0 Replies

0 Likes

ThomasRushton commented

Indexes on 40 Billion record table

Jul 11, '18 indexes·performance-tuning

0 Replies

0 Likes

DaveC edited

VERY HIGH PAGE READS AND WRITES / SEC

May 11, '18 memory·performance-tuning·memory-utilization·performance-metrics·waits

0 Replies

0 Likes

SQLserverlover answered

Need help with SP

May 9, '18 stored-procedures·sql-server-2012·performance-tuning·sql-server-2014

1 Reply

0 Likes

borispinsky commented

Does cost threshold for parallelism parameter could influence on serial plans without changing it to Parallel?

Nov 29, '17 performance·performance-tuning·parallelism·optimizer

0 Replies

0 Likes

TrekOnAZ answered

Will Number of columns in a table can affect performance in SQL server?

Nov 8, '17 performance-tuning

5 Replies

4 Likes

rvsc49 commented

Investigate Index usefulness

Jul 5, '17 performance·indexing·performance-tuning

0 Replies

0 Likes

Kev Riley answered

where to tune my SQL server

Mar 31, '17 performance-tuning

1 Reply

0 Likes

GPO edited

I need to performance tune a SQL Server 2014 ArcGIS server.

Nov 29, '16 sql-server·sql server 2014·performance-tuning·sql-server-2014·sql-server-2014-standard

0 Replies

0 Likes

ThomasRushton commented

Newer Server (better hardware) is slower than older

Nov 14, '16 sql-server-2008-r2·performance-tuning·sql-server-2012-express

2 Replies

1 Likes

Magnus Ahlkvist answered

Stored procedure with recompile causing CPU spike

Oct 25, '16 performance-tuning·stored procedures·cpu·cpu utilization

1 Reply

0 Likes

GPO edited

SQL QUERY NIGHTMARE!

Sep 27, '16 performance-tuning·query-tuning

0 Replies

0 Likes

Magnus Ahlkvist answered

Database latency and page locks waits

Sep 14, '16 performance-tuning·locking

1 Reply

0 Likes

Wilfred van Dijk answered

How to manipulate the sys.dm_exec_Procedure_Stats?

Jun 28, '16 performance-tuning·performance-metrics·io

1 Reply

0 Likes

Kev Riley commented

Indexes on hierarchical database running slow

Mar 23, '16 sql server 2008 r2·index·performance-tuning·hierarchical-query

1 Reply

1 Likes

580 Posts

120 Users

0 Followers

Topic Experts

There are no topic experts for this topic. Participate in the posts in this topic to earn reputation and become an expert.

First time here? Check out the FAQ.

Performance-tuning

We added additional temp data files to match our 8 cores. We were expecting performance improvement after adding the files but instead the jobs are taking longer than before. We always encountered the I/O request on this drive where the temp files reside.

Indexes on 40 Billion record table

VERY HIGH PAGE READS AND WRITES / SEC

Need help with SP

Does cost threshold for parallelism parameter could influence on serial plans without changing it to Parallel?

Will Number of columns in a table can affect performance in SQL server?

Investigate Index usefulness

where to tune my SQL server

I need to performance tune a SQL Server 2014 ArcGIS server.

Newer Server (better hardware) is slower than older

Stored procedure with recompile causing CPU spike

SQL QUERY NIGHTMARE!

Database latency and page locks waits

How to manipulate the sys.dm_exec_Procedure_Stats?

Indexes on hierarchical database running slow

Topic Experts

Related Topics

Want long-form discussion and articles? Try