Analyze SQL Server performance?

I am using VSTS 2008 + C # + .Net 3.5 + ASP.Net + SQL Server 2008 Express. I am working on a 32-bit platform with Windows Server 2003. The problem I find is a simple SQL statement, such as a select / create simple table, is very small from SQL Server Management Studio.

BTW: I think this should be a problem with the machine, since the same code works correctly on another machine. But I'm not 100% sure. Maybe this machine causes an error in my code?

Any ideas how to analyze to find the bottleneck of poor performance?

+3
source share
4 answers

SQL Server Profiler .

, , SQL Server Management Studio , , ..

+3

, , , . , , , .

+1

, , , Sql Server,

DBCC MEMORYSTATUS;
+1

, , , , , (, ) .

, .

.

, , , - , .

, , , . dev, . , , .

Express, Express, , .

? , -, SQL Server, , SQl .

+1

Source: https://habr.com/ru/post/1728461/


All Articles