JqueryAdminPanelTemplateQuery Form Framework j. Former. SQL Profiler Tips and Tricks. By Mike Gunderlo Go to page 1 2 Next. If youre a developer who works with SQL Server, you probably already know about SQL Profiler, the graphical tool that lets you capture and analyzer SQL Server events in real time. Best full responsive premium HTML5 Dashboard Template in 2017. Take a look at free demos of HTML5 Dashboard Template. Enjoy. Building responsive navigations for mega sites is never an easy task. If youre working on an admin panel, chances are youll need to design and develop a. Pinwheel Slider is a customizable and responsive featured jQuery carousel WordPress slider plugin that will help you adding a very attractive featured content and. If youre not familiar with this tool, check out my previous article, Introduction to SQL Profiler. This time around, Im going to drill a bit deeper into this useful tool, offering you ten more bits of SQL Profiler that you might not have noticed already. Jquery Admin Panel Template' title='Jquery Admin Panel Template' />Using Existing Templates. When you fire up SQL Profiler and tell it to create a new trace, it pre selects some events, data columns, and filters for you. Before you start fine tuning this selection, you should know that the SQL Server team has already saved some useful starting points for you in the form of trace templates. Instead of creating a new trace, select File, Open, Trace Template. SQL Server ships with trace templates for various purposes including simply counting stored procedures, tuning your SQL statements, and measuring the duration of T SQL statements. Creating Your Own Templates. Of course, the built in trace templates wont be perfect for everything you want to do. Sooner or later youll find yourself carefully crafting a SQL Profiler trace that has the exact combination of events, filters, and data columns that you need to diagnose some common problem within your own organization. When you do, you can stash this combination away for the future as a trace template of your own. Just stop the trace and select File, Save As, Trace Template and assign it a memorable name. The next time you need the same combination you can open up the saved template and have it instantly available. Saving to a Table. One of the nice things about the SQL Profiler engine is that you can either capture data for interactive analysis right on screen, or save it for later inspection and you dont have to decide up front which of those things youre going to do. Better yet, you can save a trace in the most natural possible place right in a SQL Server table When youve created a trace that warrants keeping around for future analysis, stop the trace and select File, Save As, Trace Table. Youll be presented with the Connect to SQL Server dialog box so that you can choose the server where you want to save the trace this doesnt have to be the same server that youre profiling. Then select a database and either select an existing table or type the name of a new table, as shown in Figure 1. Click OK to save the trace. Saving a trace to a SQL Server table. Replaying a Trace. Saving your traces to a table enables one of the other exciting features of SQL Profiler replaying traces. Select File, Open, Trace Table and choose a server to connect to that has a saved trace table. Open the trace table. Now youll find that the commands on the Replay menu are active. Choose Replay, Start and SQL Profiler will let you choose a server to be the target of the replayed activity. Figure 2 shows the options that you can set for a replay. Replaying a saved trace. Why would you want to replay a trace Suppose youre debugging a problem with one of your servers say, clients are deadlocking when running a particular set of queries. You can run SQL Profiler to capture a trace of the client activity that includes the deadlocks, and then rework the stored procedures on the server that you think are causing the deadlock. Replay the stored trace, and you can see whether your fixes were effective in preventing the problem from happening again. To replay a trace, SQL Server must have certain event classes and data columns in the trace. The easiest way to make sure you have the minimum set in your trace is to start with the SQLProfiler. TSQLReplay trace template, which is one of the ones thats installed with SQL Server. Using Breakpoints. When youre replaying traces, you can use some standard debugging tools to view selected events in slow motion. Place the cursor on any line in the trace and then click F9 to set a breakpoint or click F9 a second time to clear an existing breakpoint. Then you can click F5 to run the trace to the next breakpoint. At that point you can use the F1. Alternatively, you can use CtrlF1. Locating Deadlock Causes. If youre having intermittent deadlock problems, it can be tough to figure out where theyre coming from. This is especially true if your server is busy how do you even spot the deadlocks doing by SQL Profiler can help you here. Set up a trace and in the Events selection expand the Locks group, then select the Lock Deadlock and Lock Deadlock Chain events. Download Full Movie Savages there. If you monitor for these two events, SQL Profiler will produce a trace that contains details on just the deadlocks on your server. Record whatever identifying information you want for example, the application name, logon name, and so on and youll be well on your way to figure out where the culprits are. Auditing Logins. How about tracking the user activity on your SQL ServerYou can use SQL Profiler for this too. Again, the key lies in properly choosing the events that you profile. Set up a trace that monitors the Security Audit Audit Login and Security Audit Audit Logout events, and send it to a trace table. Then youll have a persistent record right in your database of who was using the database and when they were using it. Watching for Table Scans. Another good use of SQL Profiler is to find queries that are causing table scans on your server. You want SQL Server to be using indexes to find the data that your users require not to be looking through every rowTo check, turn on a trace with the MISC Execution Plan event. This will capture the query execution plan for every query. Then look over these plans for any that include a Table Scan or Clustered Index Scan which indicates that the server is scanning all rows in the index, not that its using the index to find a particular row. You can then examine those particular queries in more detail to see whether adding additional indexes to your databases tables could make them more efficient in the future. Using Keyboard Shortcuts. Johnny Warman Screaming Jets more. Like any other Windows application, SQL Profiler supports keyboard shortcuts for more efficient use. If you use this tool frequently, youll probably want to memorize some of the most useful ones CtrlShiftDelete to clear the current trace window, CtrlF to open the Find dialog box, F3 to find the next match, ShiftF3 to find the previous match, CtrlN to open a new trace, F5 to start a replay, ShiftF5 to stop a replay, F9 to toggle a breakpoint, F1. CtrlF1. 0 to run to the cursor. Choosing Data Columns. Finally, remember that you dont always have to accept the default data columns for your traces. You might find that SQL Server suggests too much or too little data for your tastes. In many cases, the NT User Name and application name will be irrelevant for troubleshooting SQL issues, and you can remove them from the data to avoid cluttering up the display. On the other hand, if youre tracing events for multiple databases, youll probably want to throw in the database name. Theres a lot of other information available, from the duration of the event to the name of the object affected by the current statement, so take a look at the list before you just blindly click OK. And Yes, Theres More. As you should be able to tell by now, SQL Profiler is a vital tool for diagnosing SQL Server issues of all types. Charisma free, responsive, multiple skin admin template. Update 2. 1 July 2. Charisma is now on Bootstrap 3. Charisma is a full featured, free, premium quality, responsive, HTML5 admin template or backend template based on Bootstrap 3 from Twitter, it comes with 9 different themes to suit your style and application type. Charisma helps you minimize the repeat work you have to do on you projects. You can re use Charisma as a base or as a package for your admin panel. Its free for personal and commercial use and you can use it in multiple sites. I have put a lot of effort on this, I just expect a share on Twitter or Facebook from you as a Thank you. View Live Demo View on Git. Hub  Download An alternative Download Link if the Download button doesnt work. It is featured with many plugins and UI elements to ease your work. It works on all major browsers and optimizes itself for tablets and mobile phones. Above all its 1. FREE and open source. It is licensed under Apache License v. Issues and pull requests on Git. Hub are always welcome. Features. 9 different themes. Fully responsive, optimized UI for tablets and mobile phones, see how it looks on different devices. Based on Bootstrap 3. Grandmother friendly, works on IE9. Commented code. Custom product tour, see example. Grid system, see example. Charts, including, pie, stack, flot, realtime etc. Data tables. Widget boxes, collapsible, sortable, closable, see example. Photo gallery, see example. Ajaxified menus. Full calendar, monthly weekly, daily, with todo list. Custom error page. Auto active link detection and much more. UI Elements. Custom Tooltip. Popover. Star Rating. Toggle Switch. Tag Boxes. Multiple File Upload. Dialog Box. Auto Growing Textarea. Ajax Loaders. Progress Bars. Alerts. Pop Notifications. Animations. Enjoy.