Quote:
Originally Posted by xavi
It's Server Side Trace.
|
LOL I know xD. Server side or not it's same. this is the processor which will work.
thi application will make request on the historic transaction file (LDF) it will make your hard drive working. At the same time your SRO Server will make transaction on Data base (MDF) which will generate transaction LDF to log the MDF transaction (Just on edit DB : INSERT/DELETE/UPDATE).
It will depends on Process & HDD server.
After that if SQL profiler is continusly executed it will growing up in memory :
1 result transaction (in the list) = x bytes place in memory.
If your computer has just 2-4GB of RAM you can make a blue screen or your application will crash <--- the most probability because NT kernel has an overflow security which stop application when it exced 2GB for x86 Windows server. For x64 when your application will exceed the necessary memory limit for System.