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
Stewartskist (not verified)
Fri, 12/07/2019 - 18:04
Permalink
14lw52ge
Viagra synthroid synthroid trazodone hcl acyclovir PREDNISONE 40MG Buy Provera advair diskus
Stewartskist (not verified)
Fri, 12/07/2019 - 17:34
Permalink
14lw52ge
Viagra synthroid synthroid trazodone hcl acyclovir PREDNISONE 40MG Buy Provera advair diskus
Ernestotah (not verified)
Fri, 12/07/2019 - 14:57
Permalink
buy viagra 25 mg 356 mg
Howdy! buy viagra great web page.
Ernestotah (not verified)
Fri, 12/07/2019 - 14:54
Permalink
buy viagra 25 mg 356 mg
Howdy! buy viagra great web page.
Michaelexpor (not verified)
Fri, 12/07/2019 - 12:57
Permalink
viagra online pharmacy 297 mg
Howdy! hcg online pharmacy excellent website.
Michaelexpor (not verified)
Fri, 12/07/2019 - 12:54
Permalink
viagra online pharmacy 297 mg
Howdy! hcg online pharmacy excellent website.
Michaelexpor (not verified)
Fri, 12/07/2019 - 12:51
Permalink
viagra online pharmacy 297 mg
Howdy! hcg online pharmacy excellent website.
Michaelexpor (not verified)
Fri, 12/07/2019 - 12:47
Permalink
viagra online pharmacy 297 mg
Howdy! hcg online pharmacy excellent website.
RebImparf (not verified)
Fri, 12/07/2019 - 00:34
Permalink
Propecia Genuine Kelattict
Best Price Cialis 20mg Doxycycline 100mg Tablets In Canada Levitra Erfahrungsaustausch [url=http://buyoxys.com]mail order levitra[/url] Erfahrungen 777 Tablets Propecia En Productos De Farmacia
RebImparf (not verified)
Fri, 12/07/2019 - 00:21
Permalink
Propecia Genuine Kelattict
Best Price Cialis 20mg Doxycycline 100mg Tablets In Canada Levitra Erfahrungsaustausch [url=http://buyoxys.com]mail order levitra[/url] Erfahrungen 777 Tablets Propecia En Productos De Farmacia
Michaelexpor (not verified)
Thu, 11/07/2019 - 17:35
Permalink
online pharmacies reviews 147 mg
Hi there! legit online pharmacies beneficial web site.
Michaelexpor (not verified)
Thu, 11/07/2019 - 17:27
Permalink
online pharmacies reviews 147 mg
Hi there! legit online pharmacies beneficial web site.
Michaelexpor (not verified)
Thu, 11/07/2019 - 17:25
Permalink
online pharmacies reviews 147 mg
Hi there! legit online pharmacies beneficial web site.
Michaelexpor (not verified)
Thu, 11/07/2019 - 17:22
Permalink
online pharmacies reviews 147 mg
Hi there! legit online pharmacies beneficial web site.
RebImparf (not verified)
Thu, 11/07/2019 - 11:03
Permalink
Cialis Stripes Kaufen Kelattict
Par 701 Clomid For Sale Dhea Propecia cialis cheapest online prices Propecia A Diez Dias Cialis Mas Viagra
Brettirrix (not verified)
Thu, 11/07/2019 - 06:33
Permalink
i2ysjia7
buspar clomid ventolin amoxil azithromycin z-pack atenolol Zithromax furosemide amoxil
Brettirrix (not verified)
Thu, 11/07/2019 - 04:44
Permalink
o037785b
hydrochlorothiazide
Brettirrix (not verified)
Thu, 11/07/2019 - 04:41
Permalink
o037785b
hydrochlorothiazide
Randcer (not verified)
Thu, 11/07/2019 - 01:01
Permalink
A Vendre Clomid Sur Internet LesBich
Propecia En Hombres levitra plus Amoxicillin Flavor Comparatif Cialis Viagra Levitra
Randcer (not verified)
Thu, 11/07/2019 - 00:53
Permalink
A Vendre Clomid Sur Internet LesBich
Propecia En Hombres levitra plus Amoxicillin Flavor Comparatif Cialis Viagra Levitra
Michaelexpor (not verified)
Wed, 10/07/2019 - 02:54
Permalink
testosterone online pharmacy 109 mg
Howdy! online pharmacy programs beneficial web site.
Michaelexpor (not verified)
Wed, 10/07/2019 - 02:51
Permalink
testosterone online pharmacy 109 mg
Howdy! online pharmacy programs beneficial web site.
Michaelexpor (not verified)
Wed, 10/07/2019 - 02:46
Permalink
testosterone online pharmacy 109 mg
Howdy! online pharmacy programs beneficial web site.
Michaelexpor (not verified)
Wed, 10/07/2019 - 02:39
Permalink
testosterone online pharmacy 109 mg
Howdy! online pharmacy programs beneficial web site.
Ernestotah (not verified)
Wed, 10/07/2019 - 00:55
Permalink
buy viagra usa 344 mg
Hi there! buy viagra good website.
Ernestotah (not verified)
Wed, 10/07/2019 - 00:52
Permalink
buy viagra usa 344 mg
Hi there! buy viagra good website.
Ernestotah (not verified)
Wed, 10/07/2019 - 00:43
Permalink
buy viagra usa 344 mg
Hi there! buy viagra good website.
Ernestotah (not verified)
Wed, 10/07/2019 - 00:38
Permalink
buy viagra usa 344 mg
Hi there! buy viagra good website.
MiltonSOR (not verified)
Tue, 09/07/2019 - 22:16
Permalink
viagra cheap 338 mg
Howdy! viagra 100mg beneficial web site
Stewartskist (not verified)
Tue, 09/07/2019 - 22:15
Permalink
p5k6yymm
buy amoxicillin Trazodone hydrochlorothiazide 12.5 mg tablets amoxil buy clonidine synthroid buy online Buy Diflucan Metformin Er 1000 Mg levitra 20mg price buy ventolin vardenafil 20 mg
MiltonSOR (not verified)
Tue, 09/07/2019 - 22:13
Permalink
viagra cheap 338 mg
Howdy! viagra 100mg beneficial web site
MiltonSOR (not verified)
Tue, 09/07/2019 - 22:07
Permalink
viagra cheap 338 mg
Howdy! viagra 100mg beneficial web site
MiltonSOR (not verified)
Tue, 09/07/2019 - 22:04
Permalink
viagra cheap 338 mg
Howdy! viagra 100mg beneficial web site
Stewartskist (not verified)
Tue, 09/07/2019 - 21:58
Permalink
p5k6yymm
buy amoxicillin Trazodone hydrochlorothiazide 12.5 mg tablets amoxil buy clonidine synthroid buy online Buy Diflucan Metformin Er 1000 Mg levitra 20mg price buy ventolin vardenafil 20 mg
Stepplups (not verified)
Tue, 09/07/2019 - 20:50
Permalink
Viagra Pfizer Pas Cher En Quimper Elllayego
Kamagra En Ligne En Suisse Comprar Levitra Sin Receta En Madrid Cheap Acyclovir Fast levitra for sale Discount Nexium Prescription
Stepplups (not verified)
Tue, 09/07/2019 - 20:40
Permalink
Viagra Pfizer Pas Cher En Quimper Elllayego
Kamagra En Ligne En Suisse Comprar Levitra Sin Receta En Madrid Cheap Acyclovir Fast levitra for sale Discount Nexium Prescription
MatUtibra (not verified)
Tue, 09/07/2019 - 08:07
Permalink
Antabuse Disulfiram Online MatUtibra
Tamoxifene Arrow Using Cephalexin On Pregnant Dogs Dapoxetine Chlorhydrate propecia caracas Generic For Cialis Buy Dexamethasone Online order accutane online no prescription
MatUtibra (not verified)
Tue, 09/07/2019 - 08:02
Permalink
Antabuse Disulfiram Online MatUtibra
Tamoxifene Arrow Using Cephalexin On Pregnant Dogs Dapoxetine Chlorhydrate propecia caracas Generic For Cialis Buy Dexamethasone Online order accutane online no prescription
MatUtibra (not verified)
Tue, 09/07/2019 - 07:54
Permalink
Antabuse Disulfiram Online MatUtibra
Tamoxifene Arrow Using Cephalexin On Pregnant Dogs Dapoxetine Chlorhydrate propecia caracas Generic For Cialis Buy Dexamethasone Online order accutane online no prescription
Michaelexpor (not verified)
Tue, 09/07/2019 - 07:27
Permalink
aetna online pharmacy 436 mg
Hi there! online pharmacy oxycodone 30mg great internet site.
Michaelexpor (not verified)
Tue, 09/07/2019 - 07:18
Permalink
aetna online pharmacy 436 mg
Hi there! online pharmacy oxycodone 30mg great internet site.
Michaelexpor (not verified)
Tue, 09/07/2019 - 07:15
Permalink
aetna online pharmacy 436 mg
Hi there! online pharmacy oxycodone 30mg great internet site.
MiltonSOR (not verified)
Tue, 09/07/2019 - 02:19
Permalink
buy viagra medication 91 mg
Hello there! buy viagra pills online great web site
MiltonSOR (not verified)
Tue, 09/07/2019 - 02:16
Permalink
buy viagra medication 91 mg
Hello there! buy viagra pills online great web site
MiltonSOR (not verified)
Tue, 09/07/2019 - 02:10
Permalink
buy viagra medication 91 mg
Hello there! buy viagra pills online great web site
Stepplups (not verified)
Tue, 09/07/2019 - 01:23
Permalink
Acheter Du Cialis Ligne Elllayego
Fineviagra cialis Dutasteride Website Cialis Dose Amoxicillin With Other Drugs
Stepplups (not verified)
Tue, 09/07/2019 - 01:16
Permalink
Acheter Du Cialis Ligne Elllayego
Fineviagra cialis Dutasteride Website Cialis Dose Amoxicillin With Other Drugs
VirgilStots (not verified)
Tue, 09/07/2019 - 00:14
Permalink
best online pharmacy viagra 372 mg
Howdy! pharmacy technician online program beneficial web site
VirgilStots (not verified)
Tue, 09/07/2019 - 00:11
Permalink
best online pharmacy viagra 372 mg
Howdy! pharmacy technician online program beneficial web site
MiltonSOR (not verified)
Mon, 08/07/2019 - 03:25
Permalink
viagra 100mg 321 mg
Hello! buy viagra medication very good web site
Pages