Alex Lima

Category: Tuning

March 26, 2011

|

General DBA, Tuning

DBCC TRACEON

There are 2 types of DBCC TRACEON (session or global). Session trace is turned on that session only and global… READ MORE
March 26, 2011

|

SQL Server, Tuning

How to execution plan on SQLServer

In SQLServer Managment Studio to the execution plan one can use one of the following SET commands “SET SHOWPLAN_XML ON”… READ MORE
November 15, 2010

|

SQL Server, Tuning

SQL Statement in cache, it’s execution time

— Display SQL statement (SQLServer 2005 and SQLServer 2008), it displays creation time, last exeuction time, max time it ran… READ MORE
October 4, 2010

|

SQL Server, Tuning

List locks held by a session

To list locks held by a current session select convert (smallint, req_spid) As spid, rsc_dbid As dbid, rsc_objid As ObjId,… READ MORE
October 4, 2010

|

SQL Server, Tuning

List blocked sessions in SQLServer

List sessions that are being blocked select spid , blocked being_blocked , db_name(dbid) , login_time , last_batch , program_name from… READ MORE
February 7, 2010

|

SQL Server, Tuning

SET STATISTICS

SET STATISTICS TIME [ON|OFF] – Tells how much CPU time and time taken to parse and compile and also the… READ MORE

Recent posts

February 10, 2026

Converting GoldenGate Classic PUMP to Dist Path with complex filtering
February 2, 2026

Step-by-Step: Using OpenAI Embeddings with Oracle GoldenGate 26ai
January 10, 2026

Navigating the Big Data Maze: Choosing the Right Data Format

Quote of the week

“Control what I can control”
~ Alex Lima

Alex Lima

About

Taking one day at a time.

Follow Us

Blog at WordPress.com.