Tagged Questions

5
votes
0answers
38 views

Troubleshooting SOS_SCHEDULER_YIELD wait

Running our corporate ERP (Dynamics AX 2012), I noticed our production environment seemed much slower than our development systems. After performing the same activities in both the development and ...
2
votes
2answers
38 views

Performance effect of indexing foreign keys

My database is for an HR application with performance reviews and I am interested in whether I should index my foreign key. There are two tables involved. The first is a ratings table with 2 columns: ...
1
vote
3answers
70 views

Improve performance by partitioning

I'm using SQL Server 2012. I’m using CTE to create an orders table from the items table. The final count for the orders table is around 120 million. It is taking about 2 hours for the whole process. ...
1
vote
1answer
78 views

SQL Server bulk insert performance

I’m running sql server 2012 and the installed ram on that machine is 128 GB. The performance of the bulk insert is very low. The bulk insert of 10 million records takes about 2 hours. We have checked ...
9
votes
4answers
1k views

SQL Server 2012 slower than 2008

I migrated a large website and database from an older server (Windows 2008 / SQL Server 2008 / 16 GB RAM / 2 x 2.5 GHz Quad Core / SAS disks) to a newer, much better server (Windows 2008 R2 / SQL ...
3
votes
1answer
201 views

Performance effects of database file size and available space

I have set the autogrowth and maxsize properties to: By 10 MB, Unlimited When I look at the Properties -> General Tab by right-clicking the database in SSMS, I see the file size is 2249MB with 6.1 ...
2
votes
0answers
78 views

How To Analyse Index Scans

I am using merge replication with SQL Server 2012. During a sync using a merge agent there are a large number of index scans. I can see this by running a profile capturing SCAN:Started and ...
3
votes
4answers
371 views

Is it advantageous to scale out using multiple SQL Server instances on the same server?

For a use-case of 9 databases spread across 3 time zones, is it advantagous to spread the databases onto multiple SQL Server instances on the same server? What will I gain and what will I lose? ...
13
votes
2answers
653 views

Why does DELETE leave a lingering effect on performance?

At the end is a test script for comparing the performance between a @table variable and a #temp table. I think I've set it up correctly - the performance timings are taken outside of the ...
2
votes
1answer
35 views

In real terms, how much effect does a bad fillfactor have on performance?

There's a storm brewing, or maybe I should say firestorm. A customer has recently implemented SQL Server 2012 Always On but that's not the most important bit. A list of fires to be put out has been ...
3
votes
2answers
290 views

SQL Server 2012 - Frequent SELECT and UPDATE on bit column. Index doesn't help

I have a SQL Server table with about 2 million rows in, this table stores short textual documents. Here's my schema: CREATE TABLE Documents ( documentId bigint IDENTITY NOT NULL, content ...