Top "Sql-server-performance" questions

SQL Server 100% CPU Utilization - One database shows high CPU usage than others

We have an SQL server with about 40 different (about 1-5GB each) databases. The server is an 8 core 2.3G CPU …

sql-server sql-server-2005 cpu-usage sql-server-performance

Constant SQL Server 80% CPU Utilization

We have a small (for now) Asp.Net MVC 5 website on a dedicated VPS. When I go to the server …

asp.net performance sql-server-2012 cpu-usage sql-server-performance

stored procedure is execution taking long time in sql server

I have a table called Transaction_tbl with more than 400 000 records in it. This is the table structure: CREATE TABLE […

sql-server sql-server-2008 stored-procedures sql-server-performance

Indexes with included columns, what's the difference?

I've never really understood the difference between these two indexes, can someone please explain what the difference is (performance-wise, how …

sql sql-server tsql database-indexes sql-server-performance

Best way to track locks - SQL Server

We have a new sp getting released and during testing we found that when it runs its blocking other OLTP …

sql-server database sql-server-performance

SQL Server: 12% index scan density and 50% fragmentation. How bad is "bad"?

How much fragmentation is bad? How low of scan density is too low? How low does scan density is bad? …

sql-server sql-server-2000 indexing fragmentation sql-server-performance