MSSQL Traceflags — Deadlocks

SQL 2005, You can enable trace­flags to allow MSSQL Serv­er pro­duce more verb­ose inform­a­tion to error­log. Trace flag 1222 Trace flag 1204


MSSQL DMVs — Blockings

This is a very good DMV script that gives you blocking/​​locking even on page level and the SQL state­ment each spid is run­ning at the time.   SELECT tl.request_session_id AS Wait­ing­Ses­sionID ‚wt.blocking_session_id AS Block­ing­Ses­sionID ‚wt.resource_description ‚wt.wait_type ‚wt.wait_duration_ms ‚DB_NAME(tl.resource_database_id) AS Data­base­Name ‚tl.resource_associated_entity_id AS Waitin­gAs­so­ci­atedEn­tity ‚tl.resource_type AS Wait­in­gRe­source­Type ‚tl.request_type AS Wait­in­gRe­quest­Type ‚wrt.[text] AS Wait­ingT­Sql ‚btl.request_type Block­in­gRe­quest­Type ‚brt.[text] AS […]


Sybase IQ Introduction

Sybase IQ is an ana­lyt­ics serv­er designed spe­cific­ally for ana­lyt­ics, data ware­hous­ing, and busi­ness intel­li­gence envir­on­ments. Dis­tin­guished from con­ven­tion­al data­bases by its column-ori­en­ted, grid-based archi­tec­ture, pat­en­ted data com­pres­sion, and advanced query optim­izer, Sybase IQ is deployed in a wide vari­ety of set­tings deliv­er­ing unmatched per­form­ance, flex­ib­il­ity, and eco­nomy in even the most chal­len­ging report­ing and […]


Enlarge TCP window to boost network transfer speed

Pro­ced­ure for rais­ing net­work lim­its under Sol­ar­is All sys­tem TCP para­met­ers are set with the ‘ndd’ tool (man 1 ndd). Para­met­er val­ues can be read with:  ndd /​dev/​tcp [para­met­er] and set with:  ndd ‑set /​dev/​tcp [para­met­er] [value] RFC1323 timestamps, win­dow scal­ing and RFC2018 SACK should be enabled by default. You can double check that these are correct: […]