{"id":629,"date":"2013-12-19T11:08:09","date_gmt":"2013-12-19T09:08:09","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=629"},"modified":"2013-12-19T11:08:09","modified_gmt":"2013-12-19T09:08:09","slug":"mssql-server-performans-testi-sorgusu-query","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2013\/12\/mssql-server-performans-testi-sorgusu-query\/","title":{"rendered":"MsSql Server Performans Testi Sorgusu"},"content":{"rendered":"

A\u015fa\u011f\u0131daki query yi management studio ile \u00e7al\u0131\u015ft\u0131rarak sql sunucunuzun sorgulara cevap verme s\u00fcresini \u00f6l\u00e7ebilirsiniz.<\/p>\n

<\/a>Source code<\/a><\/td><\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>
DECLARE @Loops INT SET<\/span> @Loops =<\/span> 1\nDECLARE @CPU INT SET<\/span> @CPU =<\/span> @@CPU_BUSY\nDECLARE @StartDate DATETIME SET<\/span> @StartDate =<\/span> GETDATE(<\/span>)<\/span>\n \nWHILE @Loops <=<\/span> 1000000\nBEGIN\n    IF<\/span> COALESCE(<\/span>'123'<\/span>,<\/span> '456'<\/span>)<\/span> =<\/span> '456'<\/span> \n            PRINT 1\n    SET<\/span> @Loops =<\/span> @Loops +<\/span> 1<\/span>  \nEND\n \nPRINT 'COALESCE, both non-NULL'<\/span>\nPRINT 'Total CPU time: '<\/span> +<\/span> CONVERT(<\/span>varchar,<\/span> @@CPU_BUSY -<\/span> @CPU)<\/span> \nPRINT 'Total milliseconds: '<\/span> +<\/span> CONVERT(<\/span>varchar,<\/span> DATEDIFF(<\/span>ms,<\/span> @StartDate,<\/span> GETDATE(<\/span>)<\/span>)<\/span>)<\/span>\nPRINT ''<\/span>  \nGO\n \n--==================================================<\/span>\n \nDECLARE @Loops INT SET<\/span> @Loops =<\/span> 1\nDECLARE @CPU INT SET<\/span> @CPU =<\/span> @@CPU_BUSY\nDECLARE @StartDate DATETIME SET<\/span> @StartDate =<\/span> GETDATE(<\/span>)<\/span>\n \nWHILE @Loops <=<\/span> 1000000\nBEGIN  \n    IF<\/span> ISNULL(<\/span>'123'<\/span>,<\/span> '456'<\/span>)<\/span> =<\/span> '456'<\/span>\n            PRINT 1  \n    SET<\/span> @Loops =<\/span> @Loops +<\/span> 1<\/span>\nEND\n \nPRINT 'ISNULL, both non-NULL'<\/span>  \nPRINT 'Total CPU time: '<\/span> +<\/span> CONVERT(<\/span>varchar,<\/span> @@CPU_BUSY -<\/span> @CPU)<\/span>\nPRINT 'Total milliseconds: '<\/span> +<\/span> CONVERT(<\/span>varchar,<\/span> DATEDIFF(<\/span>ms,<\/span> @StartDate,<\/span> GETDATE(<\/span>)<\/span>)<\/span>)<\/span>  \nPRINT ''<\/span>\nGO<\/pre><\/div><\/div>\n
\u0130\u015flem sonucunda a\u015fa\u011f\u0131daki gibi bir de\u011fer almal\u0131s\u0131n\u0131z.<\/p>\n
COALESCE, both non-NULL
\nTotal CPU time: 30
\nTotal milliseconds: 1110<\/p>\n
ISNULL, both non-NULL
\nTotal CPU time: 33
\nTotal milliseconds: 1246<\/p>\n
Ayhan ARDA<\/p>\n
\"Share<\/a>