tag:blogger.com,1999:blog-8404923189480764435.comments2017-05-26T22:11:09.908-07:00Bernie's Performance Testing BlogBernie Velivishttp://www.blogger.com/profile/14907638792737910091noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8404923189480764435.post-40240923654220356812013-04-12T01:40:51.552-07:002013-04-12T01:40:51.552-07:00My two cents on QURE DBSOPHIC: I totally agree wit...My two cents on QURE DBSOPHIC: I totally agree with you. Great tools, loaded about 2 GB of trace data in 30 minutes and quickly analyzed it. A definite must have tool for any DBA and also for any development team (the loading of data in a centralized SQL Server and the capability to allow developers to install the analysis tool connecting to the database so that they can check how their code is performing is very useful).<br /><br />I also liked a lot the capability to extract properly sqlized batches that can be used to tune the query via SQL profiler.Anonymoushttps://www.blogger.com/profile/06349653384193906966noreply@blogger.comtag:blogger.com,1999:blog-8404923189480764435.post-48733545585262684382010-11-29T06:30:33.576-08:002010-11-29T06:30:33.576-08:00Andrew,
I usually use PAL to analyze the entire p...Andrew,<br /><br />I usually use PAL to analyze the entire period for which I collect data. At the top of the report there are two summaries of results; the first shows alerts in chronological order, the second is organized by resource (CPU, Memory, Network, etc). This gives you two indexes into the results of it's analysis.<br /><br />Now, if I know that something bad happened at a specific time, I would make a copy of the .CSV file and delete all rows except those 15 minutes before and after the event. This would allow me to focus on alerts more likely to be related to the problem I am investigating. The sample report I posted here was for 15 minutes +/- from the time of the performance problem I was investigating. <br /><br />If I had no reports of a specific problem, I'd use PAL to analyze all the data and then look for alerts that indicate either configuration problems or hardware components with heavy utilization. This reduces a LOT of manual work in formating, graphing, etc... but I still need to review the alerts and apply my own analysis to determine what actions, if any, need to be taken.Bernie Velivishttps://www.blogger.com/profile/14907638792737910091noreply@blogger.comtag:blogger.com,1999:blog-8404923189480764435.post-9843750592864138372010-11-29T06:18:07.326-08:002010-11-29T06:18:07.326-08:00Thanks, I shall look at DBSophic’s website.
Howe...Thanks, I shall look at DBSophic’s website. <br /><br />However, I have a question about PAL.<br />When you are working with PAL for performance analysis for a large time segment of data, do you get PAL to analyze the whole time period or individual segments?Andrewhttp://www.1202performance.comnoreply@blogger.comtag:blogger.com,1999:blog-8404923189480764435.post-45467880918483891622010-01-12T04:08:35.403-08:002010-01-12T04:08:35.403-08:00Hi Bernie ,
Nice to see your writings after long t...Hi Bernie ,<br />Nice to see your writings after long time....<br />very impressive ! we are waiting for more ......<br />@gorakshnathgorakshnathhttps://www.blogger.com/profile/07779973679542490734noreply@blogger.com