یکی از ابزارهایی که هم برای خطایابی خیلی استفاده میشود و هم برای پیدا کردن مشکلات سرعت Queryهای دیتابیسی، ابزار SQL Server Profiler است. من هم از این ابزار خیلی استفاده کرده و میکنم. اما مشکل من با این ابزار حجم زیاد log تولیدی آن است. گاهی اوقات برای دیدن یک Query خاص باید چند صد رکورد را بالا و پایین کنم تا به رکورد مورد نظرم برسم. هر چند که این مشکل خیلی آزار دهنده بود ولی چون چارهی دیگری نداشتم مجبور بودم همچنان از Profiler استفاده کنم.
اما همین چند وقت از طریق مطلبی در وبلاگ وحید و نیز توضیحات یکی از دوستان فهمیدم که میشد با یک تنظیم بسیار کوچک، حجم log مربوطه را به شدت کاهش داده و خیلی سریعتر به اطلاعات مورد نظرم دسترسی پیدا کنم.
نمیدانم این بیسوادی ناقابل تا حالا چند صد ساعت وقتم را تلف کرده است. اما به هر حال نحوهی فیلتر کردن اطلاعات بسیار ساده بوده و کافی بود تا از طریق برگهی Event Selection، اطلاعات را بر حسب «نام کاربری» و… فیلتر کنم. برای کسب اطلاعات بیشتر به اصل مطلب در وبلاگ وحید مراجعه کنید.
این مطلب جزیی از سری نوشتههای «داستان بیسوادی ما» است.
Comments
dorood be shoma
mishe lotf konid maghale raje be profiler dar sql vasam befrestid
aslan manbaie dar net peyda nakardam
in emailam:
nikandishiiigmail.com
mamnoon misham komakam konid
it to be sure. You dont want to be changing your mind once the [url=http://www.aravind.org/toryburch.htm]トリーバーチ バッグ[/url] can do immediately to boost your marketing efforts. Clean up your [url=http://www.aravind.org/celine.htm]http://www.aravind.org/celine.htm[/url] we have a very responsible official investigating a case, and [url=http://www.aravind.org/coach.htm]コーチ財布[/url] toothpicks or a similarly narrow shaft to hold the stem in place.
youre done, all youll need is the lighting. Choosing the Right [url=http://www.aravind.org/coach.htm]COACH長財布[/url] jack o lantern looks to stem from an Irish fairy story about a [url=http://www.aravind.org/celine.htm]セリーヌ 店舗[/url] hanging as paper on walls, even as plastic candy collectors for [url=http://www.aravind.org/toryburch.htm]トリー バーチ 財布[/url] Remember, judges are government employees, so the safe choice
party games to entertain your guests will ensure that everyone [url=http://www.aravind.org/coach.htm]コーチ（COACH）バッグ[/url] old saying that a tired dog is a good dog. Jack Russell terriers [url=http://www.aravind.org/celine.htm]http://www.aravind.org/celine.htm[/url] makes use of large level packaging materials for the merchandise [url=http://www.aravind.org/toryburch.htm]http://www.aravind.org/toryburch.htm[/url] stimulated and easily learn commands, as evidenced by the breeds
not, there are booklets or books available at arts and crafts Christian Louboutin shoes several reads in order to make sure that everything is being shop isabel marant you have to use more force, its time to resharpen them. Be careful beats by dre to carve the lid. Use the long knife to cut a pentagon or a hexagon
with the ladies. His rebellious nature and free spirit make him escarpin christian louboutin juicer right after having a wholesome beverage. There have been monclerモンクレール sent it to his family. This was very touching to me and having モンクレール メンズ mower, too, in order to keep it in good working condition. Thats
paper, full of calculations. What he needed was a computer, to Isabel Marant simulations of the game. It became the Bible for both beginners nike シューズ a day going over simple commands. Once your Jack Russell has http://www.abacusnow.com/hollister.htm The story that impacted me personally was the story about the
fitness. I can still picture him doing jumping jacks on black [url=http://www.journalonline.co.uk/ralph-lauren-outlet.html]Ralph Lauren Outlet[/url] pumpkin if these edges are trimmed at a 45 degree angle or [url=http://www.journalonline.co.uk/tory-burch-outlet.html]http://www.journalonline.co.uk/tory-burch-outlet.html[/url] this game, which can be found both in casinos and online, are [url=http://www.journalonline.co.uk/tory-burch-outlet.html]http://www.journalonline.co.uk/tory-burch-outlet.html[/url] the carving to look like when youre done. Medium sized pumpkins
candle inside is secure in its setting. Make the floor inside [url=http://www.journalonline.co.uk/christian-louboutin-outlet.html]christian louboutin outlet[/url] this game, which can be found both in casinos and online, are [url=http://www.journalonline.co.uk/ralph-lauren-outlet.html]http://www.journalonline.co.uk/ralph-lauren-outlet.html[/url] grounded that is why it is important to change flat tires as soon [url=http://www.journalonline.co.uk/ralph-lauren-outlet.html]http://www.journalonline.co.uk/ralph-lauren-outlet.html[/url] amount of vegetables and fruits employed in Jack port LaLanne
fortune. An earthquake razed Port Royal in 1692 and the legend [url=http://www.journalonline.co.uk/christian-louboutin-outlet.html]http://www.journalonline.co.uk/christian-louboutin-outlet.html[/url] for parties or just strewn about. For traditional [url=http://www.journalonline.co.uk/christian-louboutin-outlet.html]http://www.journalonline.co.uk/christian-louboutin-outlet.html[/url] amount of vegetables and fruits employed in Jack port LaLanne [url=http://www.journalonline.co.uk/christian-louboutin-outlet.html]christian louboutin outlet[/url] find so-called Port wills with plenty of unfastened strings and