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
Peteritach (not verified)
Sat, 17/08/2019 - 00:13
Permalink
mail order prescription drugs from canada 270 mg
canadian pharmacy reviews online pharmacy canada pharmacy technician online course
Peteritach (not verified)
Sat, 17/08/2019 - 00:11
Permalink
mail order prescription drugs from canada 270 mg
canadian pharmacy reviews online pharmacy canada pharmacy technician online course
Peteritach (not verified)
Fri, 16/08/2019 - 02:50
Permalink
cialis from india online pharmacy 75 mg
walmart pharmacy refill online online pharmacy india trust pharmacy online
Peteritach (not verified)
Fri, 16/08/2019 - 02:48
Permalink
cialis from india online pharmacy 75 mg
walmart pharmacy refill online online pharmacy india trust pharmacy online
Peteritach (not verified)
Fri, 16/08/2019 - 02:47
Permalink
cialis from india online pharmacy 75 mg
walmart pharmacy refill online online pharmacy india trust pharmacy online
Peteritach (not verified)
Fri, 16/08/2019 - 02:46
Permalink
cialis from india online pharmacy 75 mg
walmart pharmacy refill online online pharmacy india trust pharmacy online
Ellarem (not verified)
Wed, 14/08/2019 - 17:05
Permalink
Priligy Sildenafil Dapoxetine Elloringe
Kamagra Online Cheapest Cephalexin Dosage Adult Female Furosemide Over The Counter Substitute cialis 5mg Kamagra Jelly 100 Mg Strasbourg
Ellarem (not verified)
Wed, 14/08/2019 - 16:50
Permalink
Priligy Sildenafil Dapoxetine Elloringe
Kamagra Online Cheapest Cephalexin Dosage Adult Female Furosemide Over The Counter Substitute cialis 5mg Kamagra Jelly 100 Mg Strasbourg
Brianrib (not verified)
Wed, 14/08/2019 - 05:01
Permalink
online pharmacy mexico 297 mg
Foreign Pharmacies pharmacy tech online course canadian drugs
Brianrib (not verified)
Wed, 14/08/2019 - 04:58
Permalink
online pharmacy mexico 297 mg
Foreign Pharmacies pharmacy tech online course canadian drugs
Brianrib (not verified)
Wed, 14/08/2019 - 04:54
Permalink
online pharmacy mexico 297 mg
Foreign Pharmacies pharmacy tech online course canadian drugs
Brianrib (not verified)
Wed, 14/08/2019 - 04:44
Permalink
online pharmacy mexico 297 mg
Foreign Pharmacies pharmacy tech online course canadian drugs
Williamdow (not verified)
Wed, 14/08/2019 - 01:41
Permalink
buy medication without an rx 121 mg
online pharm xanax from mexico pharmacy canadianpharm365.com/#canadian pharmacy no prescription viagra
Williamdow (not verified)
Wed, 14/08/2019 - 01:37
Permalink
buy medication without an rx 121 mg
online pharm xanax from mexico pharmacy canadianpharm365.com/#canadian pharmacy no prescription viagra
Williamdow (not verified)
Wed, 14/08/2019 - 01:27
Permalink
buy medication without an rx 121 mg
online pharm xanax from mexico pharmacy canadianpharm365.com/#canadian pharmacy no prescription viagra
Williamdow (not verified)
Wed, 14/08/2019 - 01:24
Permalink
buy medication without an rx 121 mg
online pharm xanax from mexico pharmacy canadianpharm365.com/#canadian pharmacy no prescription viagra
BrianDib (not verified)
Tue, 13/08/2019 - 06:15
Permalink
online compounding pharmacy 170 mg
pet pharmacy online generic viagra online canadian pharmacy online pharmacies canada
BrianDib (not verified)
Tue, 13/08/2019 - 06:11
Permalink
online compounding pharmacy 170 mg
pet pharmacy online generic viagra online canadian pharmacy online pharmacies canada
BrianDib (not verified)
Tue, 13/08/2019 - 06:09
Permalink
online compounding pharmacy 170 mg
pet pharmacy online generic viagra online canadian pharmacy online pharmacies canada
BrianDib (not verified)
Tue, 13/08/2019 - 06:00
Permalink
online compounding pharmacy 170 mg
pet pharmacy online generic viagra online canadian pharmacy online pharmacies canada
Brianrib (not verified)
Tue, 13/08/2019 - 03:01
Permalink
reputable online pharmacies 427 mg
best online pharmacy xanax online pharmacy technician course best canadian pharmacy online
Brianrib (not verified)
Tue, 13/08/2019 - 02:53
Permalink
reputable online pharmacies 427 mg
best online pharmacy xanax online pharmacy technician course best canadian pharmacy online
Brianrib (not verified)
Tue, 13/08/2019 - 02:49
Permalink
reputable online pharmacies 427 mg
best online pharmacy xanax online pharmacy technician course best canadian pharmacy online
Brianrib (not verified)
Tue, 13/08/2019 - 02:40
Permalink
reputable online pharmacies 427 mg
best online pharmacy xanax online pharmacy technician course best canadian pharmacy online
Brettirrix (not verified)
Mon, 12/08/2019 - 22:22
Permalink
4p9chn6v
medrol
Brettirrix (not verified)
Mon, 12/08/2019 - 21:58
Permalink
4p9chn6v
medrol
BrianDib (not verified)
Mon, 12/08/2019 - 04:55
Permalink
trusted online pharmacy reviews 414 mg
online pharmacy technician training legal online pharmacy walmart online pharmacy
Brianrib (not verified)
Mon, 12/08/2019 - 04:47
Permalink
online pharmacy technician certification 261 mg
pharmacy online usa legal online pharmacy provigil online pharmacy
BrianDib (not verified)
Mon, 12/08/2019 - 04:46
Permalink
trusted online pharmacy reviews 414 mg
online pharmacy technician training legal online pharmacy walmart online pharmacy
Brianrib (not verified)
Mon, 12/08/2019 - 04:43
Permalink
online pharmacy technician certification 261 mg
pharmacy online usa legal online pharmacy provigil online pharmacy
BrianDib (not verified)
Mon, 12/08/2019 - 04:42
Permalink
trusted online pharmacy reviews 414 mg
online pharmacy technician training legal online pharmacy walmart online pharmacy
Brianrib (not verified)
Mon, 12/08/2019 - 04:40
Permalink
online pharmacy technician certification 261 mg
pharmacy online usa legal online pharmacy provigil online pharmacy
Brianrib (not verified)
Mon, 12/08/2019 - 04:36
Permalink
online pharmacy technician certification 261 mg
pharmacy online usa legal online pharmacy provigil online pharmacy
JamaalRuify (not verified)
Sun, 11/08/2019 - 15:55
Permalink
buy propecia cheap 120 mg
buy propecia online buy finasteride online buy propecia no rx
JamaalRuify (not verified)
Sun, 11/08/2019 - 15:49
Permalink
buy propecia cheap 120 mg
buy propecia online buy finasteride online buy propecia no rx
JamaalRuify (not verified)
Sun, 11/08/2019 - 15:45
Permalink
buy propecia cheap 120 mg
buy propecia online buy finasteride online buy propecia no rx
JamaalRuify (not verified)
Sun, 11/08/2019 - 15:42
Permalink
buy propecia cheap 120 mg
buy propecia online buy finasteride online buy propecia no rx
Michaelbesse (not verified)
Sun, 11/08/2019 - 07:29
Permalink
where buy imitrex 286 mg
http://imitrex-sumatriptan.com/ - buy imitrex cheap buy imitrex pills buy generic imitrex
Michaelbesse (not verified)
Sun, 11/08/2019 - 07:27
Permalink
where buy imitrex 286 mg
http://imitrex-sumatriptan.com/ - buy imitrex cheap buy imitrex pills buy generic imitrex
Michaelbesse (not verified)
Sun, 11/08/2019 - 07:25
Permalink
where buy imitrex 286 mg
http://imitrex-sumatriptan.com/ - buy imitrex cheap buy imitrex pills buy generic imitrex
Michaelbesse (not verified)
Sun, 11/08/2019 - 07:22
Permalink
where buy imitrex 286 mg
http://imitrex-sumatriptan.com/ - buy imitrex cheap buy imitrex pills buy generic imitrex
Stewartskist (not verified)
Sun, 11/08/2019 - 02:46
Permalink
t19m5n9z
lexapro lasix albendazole prednisolone buy furosemide Prednisone albuterol nebulizer
Brettirrix (not verified)
Sat, 10/08/2019 - 19:14
Permalink
04zeictm
buy metformin amoxicillin 875 trazodone purchase celexa
JamaalRuify (not verified)
Sat, 10/08/2019 - 18:17
Permalink
purchase propecia 32 mg
where buy propecia order propecia buy propecia no rx
JamaalRuify (not verified)
Sat, 10/08/2019 - 18:12
Permalink
purchase propecia 32 mg
where buy propecia order propecia buy propecia no rx
JamaalRuify (not verified)
Sat, 10/08/2019 - 18:09
Permalink
purchase propecia 32 mg
where buy propecia order propecia buy propecia no rx
JamaalRuify (not verified)
Sat, 10/08/2019 - 18:02
Permalink
purchase propecia 32 mg
where buy propecia order propecia buy propecia no rx
Michaelbesse (not verified)
Sat, 10/08/2019 - 06:53
Permalink
buy imitrex online without prescription 234 mg
http://imitrex-sumatriptan.com/ - order imitrex buy imitrex pills buy imitrex online without prescription
Michaelbesse (not verified)
Sat, 10/08/2019 - 06:48
Permalink
buy imitrex online without prescription 234 mg
http://imitrex-sumatriptan.com/ - order imitrex buy imitrex pills buy imitrex online without prescription
Michaelbesse (not verified)
Sat, 10/08/2019 - 06:41
Permalink
buy imitrex online without prescription 234 mg
http://imitrex-sumatriptan.com/ - order imitrex buy imitrex pills buy imitrex online without prescription
Pages