High Performance SQL Server by Benjamin Nevarez

Author:Benjamin Nevarez
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA

To test it, try creating a temporary table, for example, using the following sentences. You can try one sentence at a time and run the previous code to inspect the allocation ring buffers and see which events are created on each statement. You can uncomment the session_id part and specify a session ID value in case you need to filter out for a specific session if you are getting too many events from other sessions:

CREATE TABLE #temp (c1 int, c2 varchar(20), c3 datetime)

INSERT INTO #temp VALUES (1, 'test', GETDATE())

DROP TABLE #temp

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.