Loading the player...

Transcript

Expand

Welcome, everyone to Precise 10 for SQL Server. I want to show you today how Precise works in the new 10.0 environment. My name is David Owen. I am the product manager. So, first of all, I just want to log in and show you Precise. And this is the new Precise environment. You see first of all I am on a chrome tab Chrome browser. And I no longer need to actually use Internet Explorer. This is the big new. The big new key thing to Precise in 10.0 is that we can run on both Chrome and Firefox as well as running on Internet Explorer. So let us look into what we need to do in terms of logging on to Precise. So the first thing I am going to do is I am going to show you the URL [uniform resource locator] that we log on to Precise. Previously in the past, you would have used a URL [uniform resource locator] like this. And you can see that is got the server name and the port number. If I click a missing Chrome it tells me that it is only currently supported. Right, it is a next Explorer and I know I am ok. So what I need to do in order to make sure that I am running this in Chrome or Firefox is a neat Pacific self-slash Precise it. And then that brings me to the login screen. So let us log in. And we taking to the Precise applications until we can see the same applications as we can see in the old Internet Explorer version that was available in 9.9. Them below the applications we can see on the left-hand side different applications. Here on the right-hand side, we got the tiers and the instances. So let us just choose one of the applications. And I have chosen this one called pound. And if I look on the right-hand side it tells me what tiers I have got. So Windows 7 OS [operating system] because with when you are talking about Windows Server today that is some. Look at the Windows Server. So the first thing you see is we have got the SQL Server tier highlighted got the innocence there and then we have got the information in the activity chart below showing all the events that are occurring in SQL Server. So let us launch Precise for SQL Server. And here you can see that we have got the dashboard. Okay, this is the same layout as we currently have in the existing 9.9 Precise application. We have tried to keep everything consistent trying to keep everything the same in terms of the look and feel. So here on the left and within the dashboard, you can see we have got the number of instances. We show the executions. We show the availability on the right-hand side. We have got the activity chart which shows where the time is being spent in a single server. And then below that, we have the findings which are obviously one of the key features of Precise. And that shows us exactly where the time is being spent. Okay, so we have got all the findings are color-coded as previously. And we are obviously able to sort of launch into Precise. So let us have a quick look at the activity chart. So I have chosen Activity chart. This is going to load the Precise activities and show us the databases below it. So again this is the same sort of thing that we saw before and the dashboard in terms of the look and feel. And then below that, we have got the databases. Okay, so you can see that the databases they sorted in descending sequence. And then we have got the information to say where that time is actually being spent. Okay so you can see obviously this foundation helps search content database is the biggest consumer of SQL. And then we have got the percentage number sessions what the average duration is the number of executions, etc. One thing that you will notice here with Precise 10.0 is that we have this little red box on most of the top columns. So if I click on that little red box you notice I got two things that actually pop up. First one is it shows me the columns. And you can see I can add or remove columns from that and change the look and feel of that. And then secondly we have got the export to Precise custom portlet. So that is now there at each of the different columns previously. We used to have a little box here on the right-hand side. But that is no longer the case. Okay so let us let us quickly dive into our database. So we bring up our database here. And then below that, we have got all the statements. So we again in Precise, as we currently have we have the ability to pick and choose what we want to see whether one. Let us see programs, login, statements, work types, availability groups, availability replicas, as well. It is one thing. And also to mention for 10.0 is availability groups is now a standard feature with in Precise 10.0. So in the statements, you can see I have got shared the top statements. Again if they are all sorted in descendants order terms of the amount of time spent in SQL Server. So this particular one I have got here is 85%. So if I click on Tune this is going to take me to the SQL tab. As we have previously done. And here we have got the execution plan. Got the SQL text here. And in terms of the detail. And then below that, we have actually got the findings. So the findings, here again, are there to help us to understand exactly what the sort of problems are with the SQL segments. So if I click on the Recommend tab here. Let us see if we can identify any recommendations that Precise has made for you. And there we go. We have got the recommendation that we got the recommendations that have been identified. So we can say things like partition functions, partition scheme, creating decks, and said as statistics is also identified there. And on the right-hand side, you know this as I click on one will actually show me the details of them. So if I click Evaluate sure now that now runs under the covers will bring back results of the evaluation. And what is going to do is it is actually going to look at that particular set of recommendations and come back and tell us what the impact is. So we can see here we have got a pie chart to show us whether there is any decrease in cost. Some of the signal segments and then below that, we have got a list of the SQL statements. So we have got. So this is exactly the same way as it is worked previously in 9.9. And below I think what you notice is things are a little bit quicker than we were before. If I go back to Activity again. You can see here if I drill down into my statements or it will actually let us change that and look at programs. So if I drill down to Programs I can see which programs again now contributing the most to the time. Let us lick on the program below that. And then again it is going to tell me with statements. Okay, so we have got these statements here within that so if I click on a statement. Okay, it is going to tell me which batch it will belong to. Okay, so this is the batch name. And if I want to find out what login he is actually using this. I just click on login here. And it tells me this is the login ID. So I can check this login. So if I won now go back up and maybe try and have a look bit more detailed that maybe some of the other statements. I can click here the Pre button so the Pre button will take me the previous. And you know this I have also got the Next button here. So the Next takes me back down until a particular login. So this is how we navigate back and forth. Now with in Precise 10.0 using the Pre Next buttons. So the Pre is taking me to the statement. If I click Pre again is taking me back to the program. I am Pre again it will not take me back to the instance. Okay, so that is some of the key features that we have got with in Precise. Let us go back to the dashboard. And let us have a look at some of the findings. So let us just change the time scale here just to sort of see what. So at times, we have got to notice now it is over two days. And we will sort of get information relevant to two days. So you notice now for each of the bar charts they represent different time slice. So here they are in our slots. Okay whereas if there we were in the eight-hour window there we would be in 15. And then time slices. So let us click on one of these find ensure so understand what it is. It says heavily access object. Okay, let us click on that. And this is going to take me to the smart toon going to tell me some details about it. Okay and we can sort of see what is going on there with that. So tell me the object it is not scalable. Okay so now let us go across through the Admin Point. So if we go to the Admin Point again you see it all looks exactly the same as we have got before. And so I want to do now just find out a couple of little minor differences that we have got you. So first of all if I go to the Installation tab you notice that everything now is just application based. There is no longer anything that is specifically to do with instances anymore. So if I click on an application. And I click Edit I get a little pop-up here which basically tells me that it is going to open an APM [application performance management] instance in […]. Because Precise is a web browser application we do occasionally need to execute some applications underneath that and this is what is happening. Good. So if I click OK am I going to open that APM [application performance management] instance installer. It is now going to bring up the installer executable for me. And there you can see we got the application installer. And this exactly the same as we have got before. So it is showing me all the different tiers that belong to this particular application installer. And I can go in. And I can go and edit it and change things around. Likewise, if I click on Management you notice I got action items, updates, and notes. So let us click on updates. And here we have got all the latest details in terms of the updates. So if I click here in terms of apply updates I can this tell me those control not a […] or a […] see. When you run Precise from the very first time in 10.0 you will have to download a new APM [application performance management] instance installer. [… ] I am clicking on this apply updates will do the download for you. Once that downloads been run and you have run the application it will then allow you to up to use the instance installer and executable. And there you go. You can see that we have now got the instance installed as an application. It is working in exactly the same way as before. So if we wanted to do an upgrade we click on the particular one that we want. Apply it and then goes to the standard process in terms of doing the upgrade. So there we are. This is Precise 10 for SQL Server. I hope you find this useful. Please come back to the idera.com website for more videos in the future. Thank you.

Precise for SQL Server’s New GUI

Precise for SQL Server helps ensure that your business applications perform at peak efficiency by collecting and analyzing key performance metrics over time. It can detect and correct the root cause of performance problems whether in the application, database, or storage. With Precise for SQL Server, organizations can monitor all SQL Server instances from a single console, optimize database performance tuning, accelerate problem resolution, and reduce IT support costs. Learn More →

Request a demo

Share This
Contact IDERA:
+1 (713) 523-4433