Activity overview
Latest activity by slimshaky
Can you calculate a substring based on another column?
I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is populating a column of file extensions based on a full filena...
Can you offset from a date in another table?
I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is offsetting a date based on a value in another table. For exam...
Can I add machine wait metrics to reports?
I would like to create a report in SQL Monitor that will send out a monthly summary of the machine overview items, so that I can go back periodically and see how my machine stats compare with those...
Why can't I match longest running queries report tile to a long running query alert
A co-worker told me I had better look at one of his sql monitor reports because I had a query that was taking longer than a day to run. He has the Longest running queries tile included in his repor...
Thanks for your help. / comments
Thanks for your help.
How can I get a more precise long running query start time?
I am researching a high resource usage event from yesterday and wanted to get a handle on which event came first. I have long running queries on one instance and deadlocks on another instance. With...
Thanks for the explanation. If I want to get a list of long running queries specific to a database, is that something that I can query against on the back end? / comments
Thanks for the explanation. If I want to get a list of long running queries specific to a database, is that something that I can query against on the back end?
How can I see alerts for a given database?
On the alerts tab, I can drill down to a server, then an instance, and then a database. However, it seems that most of my alerts do not appear when I click on a particular database. For example, I ...
What are the recommended system specs?
I have several long running sql data compares that run throughout the day. I just noticed that the box they are running on only has 2GB of RAM, and I'm wondering if this is a factor in the length o...
After further digging, I see that the Analysis tab also has baselining capabilities and that we could end up sending periodic reports based on the analysis metrics. I'm going to check further with my manager to see if either of these approaches could be sufficient to meet our needs. / comments
After further digging, I see that the Analysis tab also has baselining capabilities and that we could end up sending periodic reports based on the analysis metrics. I'm going to check further with ...