Activity overview
Latest activity by tobin
Thanks Sergio, I was testing that out and noticed that I made a mistake by including the Default options, which has IncludeDependencies as part of it. Removing the defaults took out the synonym issue. I appreciate you getting back to me. / comments
Thanks Sergio, I was testing that out and noticed that I made a mistake by including the Default options, which has IncludeDependencies as part of it. Removing the defaults took out the synonym is...
Preventing SQL Compare from DROP and CREATE SYNONYM
Hey all,We have a reporting database where on the live server we point our synonyms at [Production].[dbo].[tblName], but on our replicated server we use [Reports].[Production].[tblName].When I try ...
Hey Sam, Unfortunately not, as we're stuck to SQL 2014 for the time being. I've commented out the conditional EXEC, and even removed it, but the script still won't compare unless the query is marked as CREATE and not ALTER, so I can't get the guys to comment out the create/replace part and then compare just the script while it is an ALTER VIEW. Any other suggestions? / comments
Hey Sam,Unfortunately not, as we're stuck to SQL 2014 for the time being.I've commented out the conditional EXEC, and even removed it, but the script still won't compare unless the query is marked ...
Comparing to ALTER scripts instead of CREATE
Hey guys,All of our scripts in source control follow a pattern like this:
IF ISNULL(OBJECT_ID('dbo.vwView'),0) = 0 EXEC ('CREATE VIEW dbo.vwView AS SELECT 1 fldDummy')
GOSET QUOTED_IDENTIFIER ONSE...
Thanks for that Tianjiao, Unfortunately, because I'm just one member of the team and we don't want to lose the source control history we have that's not possible either. It will just prevent me from using this tool. We don't use SQL Source Control for the same reason - I'm using TFS to manage that, as the team I joined has used that for years. I was hoping to get more widespread adoption of the tooling. Thanks for the feedback [image] / comments
Thanks for that Tianjiao, Unfortunately, because I'm just one member of the team and we don't want to lose the source control history we have that's not possible either. It will just prevent me fr...
Comparing a db to a Scripts folder - can I exclude a subfolder?
I'm trying to run an SQL Compare against a folder we've had source controlled for years, and I am getting errors because under the structure we have a "Replication" folder. This contains some dupl...
To be honest, the only thing I would love on that dashboard view is some workload metric that would make sense - batches/s or similar... if my server is working hard, I want to know it's working on something. IE if my CPU or Disk IO or Wait spike, then is there a similar spike in activity that would justify it. But that's just me being me [image] I'd probably end up digging in regardless.
Thanks for getting back to me. / comments
To be honest, the only thing I would love on that dashboard view is some workload metric that would make sense - batches/s or similar... if my server is working hard, I want to know it's working on...
Grant wrote: »
We show it in near real time. It's only delayed by a few seconds, but, it radically reduces what happens on your server. People can absolutely disagree on whether it's the right approach.
I'd be VERY cautious of Spotlight. Of all the other vendor products out there, it's the single one I've had the most issues with. Do you know that it masks it's own calls to the server? If you really want to evaluate us against another software, pursue another vendor. I think we're better (I do have a prejudice), but the others are much safer than Spotlight.
Hey Grant,
I'm trying to show the benefits of SQL Monitor, and the guys can easily see the benefits from longtime trends, but they have a real love of Spotlight for fire-fighting. It does provide a great realtime view that allows them to see current sessions, current query times, and all queries - not just top 10.
It's handy to be able to drill in and see all blocked processes, all deadlock victims, live as things are happening.
Is there a good way to see this data in SQL Monitor?
The team here has been focused on fighting fires for a long time - and while I'd rather get us past that, this is just their fact of life - response to emergency has to be instant, and while I can run sp_whoisactive, they're used to digging straight into Spotlight and seeing a "Current state". Having a single page where we could see the current CPU, Network Speed, metrics, what's running currently process, queries, sessions - even if it's just the latest state values from the last 30-second refresh, would be brilliant for them. Is that feasible, on the roadmap, or not an option? / comments
Grant wrote: »
We show it in near real time. It's only delayed by a few seconds, but, it radically reduces what happens on your server. People can absolutely disagree on whether it's the right ...