SQL Server useful but less known features
-
Checking who is connected to the database
sp_who
SELECT
NULL as [Connections by Database],
[host_name] AS [Client Machine],
db.name AS [Database],
[program_name] AS [Client Program],
COUNT(*) AS [Open Connections]
FROM sys.dm_exec_sessions s (nolock)
LEFT JOIN sys.dm_exec_requests r (nolock) ON r.session_id = s.session_id
LEFT JOIN sys.databases db (nolock) ON db.database_id = r.database_id
WHERE s.session_id >= 50 -- Ignore SQL Server processes
GROUP BY [host_name], db.name, [program_name]
ORDER BY [Client Machine], [Database], [Client Program] -
Adjusting connection pooling settings
By default pool size is 100 per database with a command timeout (effectively a connection timeout) of 15 seconds. To increase add following to the connection string:
Connection Timeout=30;Pooling='true';Max Pool Size=200
-
Checking the size of column's contents
To check how much data the column contains:
SELECT *, DATALENGTH([column]) AS ColumnSizeInBytes FROM table
-
Using SQL Server profiler
Profiler is a powerful way to debug application performance problems, to check query execution time. If you're developing any application using SQL Server as a database, running it at least once for every application release can help with pinpointing possible performance issues. Remember the rule - there should be a constant number of queries regardless of the amount of records fetched - that way application will scale better. Sometimes it's better to replace a single complex query with more simpler queries because for each result row, columns shared by joins are repeated and delivered to client for processing many times.
Comments
NathanHit (not verified)
Wed, 19/12/2018 - 02:42
Permalink
cialis 5mg at canadaian pharmacies 83 mg
Howdy! canada pharmacies free shipping very good web site http://canadiantrustpharmacyhd.com
NathanHit (not verified)
Wed, 19/12/2018 - 02:38
Permalink
cialis 5mg at canadaian pharmacies 83 mg
Howdy! canada pharmacies free shipping very good web site http://canadiantrustpharmacyhd.com
NathanHit (not verified)
Tue, 18/12/2018 - 23:38
Permalink
canadian pharmacies cirlis 137 mg
Hi! canadian pharmacies generic viagra great web site http://canadiantrustpharmacyhd.com
NathanHit (not verified)
Tue, 18/12/2018 - 23:28
Permalink
canadian pharmacies cirlis 137 mg
Hi! canadian pharmacies generic viagra great web site http://canadiantrustpharmacyhd.com
NathanHit (not verified)
Tue, 18/12/2018 - 23:26
Permalink
canadian pharmacies cirlis 137 mg
Hi! canadian pharmacies generic viagra great web site http://canadiantrustpharmacyhd.com
NathanHit (not verified)
Tue, 18/12/2018 - 23:24
Permalink
canadian pharmacies cirlis 137 mg
Hi! canadian pharmacies generic viagra great web site http://canadiantrustpharmacyhd.com
Brettirrix (not verified)
Mon, 17/12/2018 - 06:15
Permalink
yc3pbsoq
tadacip 20 lexapro buspar lisinopril buy propecia online tadalafil 20mg lasix Torsemide buy real valtrex online prednisone tablets 5 mg
Brettirrix (not verified)
Mon, 17/12/2018 - 06:09
Permalink
yc3pbsoq
tadacip 20 lexapro buspar lisinopril buy propecia online tadalafil 20mg lasix Torsemide buy real valtrex online prednisone tablets 5 mg
AntioneGloro (not verified)
Mon, 17/12/2018 - 02:47
Permalink
buy cialis with no prescription 33 mg
Hello there! buy tadalafil buy finasteride association cialis et viagra great web site
AntioneGloro (not verified)
Mon, 17/12/2018 - 00:51
Permalink
buy cialis uk 132 mg
Howdy! purchase tadalafil purchase finasteride cialis mail very good website
AntioneGloro (not verified)
Mon, 17/12/2018 - 00:48
Permalink
buy cialis uk 132 mg
Howdy! purchase tadalafil purchase finasteride cialis mail very good website
AntioneGloro (not verified)
Sun, 16/12/2018 - 22:05
Permalink
buy cialis cheap 225 mg
Hello there! cialis buy propecia online without prescription viagra and cialis online excellent site
AntioneGloro (not verified)
Sun, 16/12/2018 - 22:00
Permalink
buy cialis cheap 225 mg
Hello there! cialis buy propecia online without prescription viagra and cialis online excellent site
AntioneGloro (not verified)
Sun, 16/12/2018 - 21:59
Permalink
buy cialis cheap 225 mg
Hello there! cialis buy propecia online without prescription viagra and cialis online excellent site
AntioneGloro (not verified)
Sun, 16/12/2018 - 21:57
Permalink
buy cialis cheap 225 mg
Hello there! cialis buy propecia online without prescription viagra and cialis online excellent site
Wesleyemunc (not verified)
Sun, 16/12/2018 - 04:15
Permalink
buy tadalafil pills 274 mg
Hello there! order cialis finasteride cialis tablets india tablets 20 mg excellent web page
Wesleyemunc (not verified)
Sun, 16/12/2018 - 02:28
Permalink
buy cialis 92 mg
Hello! [url=http://cialissmx.com/]buy cialis usa[/url] [url=http://propeciausfinasteridhq.com/]buy finasteride[/url] [url=http://cialissmx.com/]cialis profesional india[/url] excellent web page
Wesleyemunc (not verified)
Sun, 16/12/2018 - 02:23
Permalink
buy cialis 92 mg
Hello! [url=http://cialissmx.com/]buy cialis usa[/url] [url=http://propeciausfinasteridhq.com/]buy finasteride[/url] [url=http://cialissmx.com/]cialis profesional india[/url] excellent web page
AshleyVaf (not verified)
Sat, 15/12/2018 - 15:05
Permalink
buy cialis no prescription 171 mg
Hello! where buy cialis order finasteride double dose of cialis good site
AshleyVaf (not verified)
Sat, 15/12/2018 - 14:59
Permalink
buy cialis no prescription 171 mg
Hello! where buy cialis order finasteride double dose of cialis good site
AshleyVaf (not verified)
Sat, 15/12/2018 - 13:16
Permalink
cialis online 466 mg
Hi! purchase tadalafil buy propecia usa how can i buy cialis in a store in ct beneficial site
AshleyVaf (not verified)
Sat, 15/12/2018 - 13:12
Permalink
cialis online 466 mg
Hi! purchase tadalafil buy propecia usa how can i buy cialis in a store in ct beneficial site
AshleyVaf (not verified)
Sat, 15/12/2018 - 05:30
Permalink
cialis online 177 mg
Hi! purchase cialis online no prescription where buy propecia cialis 5mg daily dose price good web site
AshleyVaf (not verified)
Sat, 15/12/2018 - 04:08
Permalink
buy tadalafil online 245 mg
Hi there! cialis finasteride cialis 100mg kaufen excellent web site
AshleyVaf (not verified)
Sat, 15/12/2018 - 04:07
Permalink
buy tadalafil online 245 mg
Hi there! cialis finasteride cialis 100mg kaufen excellent web site
AshleyVaf (not verified)
Sat, 15/12/2018 - 02:11
Permalink
buy tadalafil pills 172 mg
Hello! buy cialis online without prescription buy propecia online cialis mg to take great web site
AshleyVaf (not verified)
Fri, 14/12/2018 - 23:08
Permalink
buy cialis online 73 mg
Hello! buy tadalafil no prescription buy propecia medication cialis and levitra viagra price online beneficial internet site
CharlesEnepe (not verified)
Fri, 14/12/2018 - 15:20
Permalink
canadianedrugstore com 355 mg
Hello! best pharmacy excellent web site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 13:13
Permalink
pharmacy viagra 390 mg
Hello there! order online pharmacy great site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 13:09
Permalink
pharmacy viagra 390 mg
Hello there! order online pharmacy great site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 13:05
Permalink
pharmacy viagra 390 mg
Hello there! order online pharmacy great site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 10:10
Permalink
northwest pharmacy scam 100 mg
Hi there! canadiandrugs beneficial web site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 10:07
Permalink
northwest pharmacy scam 100 mg
Hi there! canadiandrugs beneficial web site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 10:02
Permalink
northwest pharmacy scam 100 mg
Hi there! canadiandrugs beneficial web site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 06:49
Permalink
viagra from candian pharmacy 75 mg
Hi! canadian pharmacy online to usa canadianpharmacyinlinesto very good website http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 05:09
Permalink
canada online drugstore 307 mg
Hello! ed pharmacies beneficial web site http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 03:05
Permalink
free online pharmacy technician practice test 139 mg
Hi! cheap cialis at canadian pharmacy beneficial web page http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Fri, 14/12/2018 - 02:59
Permalink
free online pharmacy technician practice test 139 mg
Hi! cheap cialis at canadian pharmacy beneficial web page http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Thu, 13/12/2018 - 23:51
Permalink
candrug com 482 mg
Hello there! buying prescription drugs canada online great website http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Thu, 13/12/2018 - 23:48
Permalink
candrug com 482 mg
Hello there! buying prescription drugs canada online great website http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Thu, 13/12/2018 - 23:47
Permalink
candrug com 482 mg
Hello there! buying prescription drugs canada online great website http://canadianonlinepharmacyhq.com
CharlesEnepe (not verified)
Thu, 13/12/2018 - 23:45
Permalink
candrug com 482 mg
Hello there! buying prescription drugs canada online great website http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 15:36
Permalink
best canadian mail order pharmacies 276 mg
Hello! canadian pharmacy cialis generic very good site http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 13:46
Permalink
best online pharmacies canada 401 mg
Hi there! northwestpharmacy com coupon good web page http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 13:39
Permalink
best online pharmacies canada 401 mg
Hi there! northwestpharmacy com coupon good web page http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 13:35
Permalink
best online pharmacies canada 401 mg
Hi there! northwestpharmacy com coupon good web page http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 04:14
Permalink
mexican pharmacy cialis 119 mg
Hello there! canadian+pharmacy great website http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 04:12
Permalink
mexican pharmacy cialis 119 mg
Hello there! canadian+pharmacy great website http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 02:22
Permalink
online pharmacy scams 291 mg
Hi! canada pharmacy online cialis beneficial web page http://canadianonlinepharmacyhq.com
Ernestvab (not verified)
Thu, 13/12/2018 - 02:21
Permalink
online pharmacy scams 291 mg
Hi! canada pharmacy online cialis beneficial web page http://canadianonlinepharmacyhq.com
Pages