-
as seen on Stack Overflow
- Search for 'Stack Overflow'
If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is?
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at to see why this keeps happening? I've tried running…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time
spid=163
duration=11310646
starttime=2010-04-06 17:45:24.480
endtime=2010-04-06 17:45:35.790
reads=152
writes=2
cpu=16
eventclass=12
textdata=…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
i've picked a query out of SQL Server Profiler that says it took 1,497 reads:
EventClass: SQL:BatchCompleted
TextData: SELECT Transactions....
CPU: 406
Reads: 1497
Writes: 0
Duration: 406
So i've taken this query into Query Analyzer, so i may try to reduce…
>>> More
