Subtitles of the Movie

Let's go ahead and just look at a few examples of what we can look at from the aspect of running the statistics again. First, remember that the first aspect is running everything in the system itself. We don't to worry about what component that we're looking at because we are going to get everything. In this particular case, when I execute it because I have not defined a database-id or the file-id, I'm going to get everything. The key is that our sample is going to then tell us the milliseconds that have passed. We're going to see the number of reads that we have worked with. We are going to see the amount of time that you've had to actually wait for the process itself. So the idea is a great deal of information is given from the following information. Let's go ahead now and actually run that on a particular database itself. This is the actual example of running this on AdventureWorks. So in AdventureWorks I'm defining my database-id and then defining the actual file-id itself. I then execute the actual command and you'll see that my database-id for AdventureWorks is 11. My file-id is 2. Remember this information can be obtained from the system files themselves in the master database. It then tells me again how many milliseconds have run, the number of reads, the number of writes, the number of waits that were actually on the database itself. Now in some particular cases, we may find that we want a little bit more specifics. Let's say for instance that I wanna find out exactly how busy the database has been since the last restart. If I go ahead and run a slight variation on the command itself, you will see this time that it's going to give me the ability to see the potential reads on the system itself. The coding that you're looking at is also just a bit more complex as it's going into more definitions of what we want to see. Notice in this particular case, rather than just seeing the database-id, I'm also asking for the physical name of the Microsoft file itself. This allows me to see a little bit more information in the background. Again, remember when I'm going into the SQL data, I can look at any of the individual databases. For the purpose of these videos, I'm choosing to stay within the samples that were provided by Microsoft. So if we want to, we could see the results of it after it's actually been started or simply just see the results of it as it is running. There are many, many more parameters that we can add to this particular statistics. The concept here is to introduce the fact that along with the Performance Manager and the Task Manager, there are other third party solutions and different statistics that are included in the database programs. This particular example, we saw it in SQL Server.