Comments
Sort by recent activity
It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the default style or create a new one. I’d go for creating a new one to start. Then just step through all the different options and save the work when you’re done. As you make changes you can see a sample query or even preview the current query. It makes it really easy to get exactly what you want in terms of style. We even have a nice article telling all about it.
Hope that helps / comments
It’s pretty straightforward. You have a “Sql Prompt” menu in SSMS or VS. Click on that and then select “Edit Formatting Styles”. It’ll open up the new editor. It’s really slick. You can edit the de...
This looks like some kind of bot defining two terms, not even remotely answering the question. / comments
This looks like some kind of bot defining two terms, not even remotely answering the question.
Not a problem. I'm here to help out. / comments
Not a problem. I'm here to help out.
Yes. If you go into the Alerts management window, on the left side of the screen you'll see your servers. You can drill down to an instance and then drill down on the instance. You'll see a list of databases. Scroll down and you'll see a list of Jobs that can be expanded. Select the job you want to modify and you can control it at that level. / comments
Yes. If you go into the Alerts management window, on the left side of the screen you'll see your servers. You can drill down to an instance and then drill down on the instance. You'll see a list of...
I wouldn't want it to be a whole lot more intrusive, but I do find it a little subtle. Basically everything Steve said. Plus, is there a way to get a more complete report across the database or is it focused only on the query? / comments
I wouldn't want it to be a whole lot more intrusive, but I do find it a little subtle. Basically everything Steve said. Plus, is there a way to get a more complete report across the database or is ...
So that's cumulative query time. That database may in fact be the problem. You still don't know that 100% because the query is assigned to the database that calls it, but that query could be calling other databases. It's just this odd point that makes a perfect, "Well, yes, of course that particular database is the one using your CPU resources" difficult to say with certainty. It depends on the queries.
That said, the queries from that database are absolutely the top cost of CPU on your system. We can say that with 100% certainty.
Does that help? / comments
So that's cumulative query time. That database may in fact be the problem. You still don't know that 100% because the query is assigned to the database that calls it, but that query could be callin...
1) There's not really a ranking by database of CPU usage. In fact, the way SQL Server works, it's going to be difficult to identify that for certain because any given query could be running from one database while querying another. Which database do you put the CPU use into? You can look at transactions and other database specific metrics. Some are on the overview page and a whole bunch more are available in the Analysis page.
2) That's front and center on the Overview page. Scroll down from the sparkline one the server and you'll see a list of the current top 10 queries. You can resort that list by any of the provided columns. You can also go back in time to look at previous periods. That should show you what you're looking for. Further, clicking on the query will show you the waits for that query and you can look at the execution plan. Between the two, you get a lot of guidance on what to do to address the slow queries or the queries consuming lots of resources. / comments
1) There's not really a ranking by database of CPU usage. In fact, the way SQL Server works, it's going to be difficult to identify that for certain because any given query could be running from on...
Did you set up data purging? If so, what are the rules you have on your system? If not that, is it possible someone has access to the database and could be deleting data? / comments
Did you set up data purging? If so, what are the rules you have on your system? If not that, is it possible someone has access to the database and could be deleting data?
If the account has access to the files and the account is the one used by SQL Backup, then I'm at a loss. When everything is lined up correctly, this works fine. I'll see if we can get one of the developers to take a look. / comments
If the account has access to the files and the account is the one used by SQL Backup, then I'm at a loss. When everything is lined up correctly, this works fine. I'll see if we can get one of the d...
Can you validate that the account actually does have the rights by logging in as that account and then navigating to the correct share? / comments
Can you validate that the account actually does have the rights by logging in as that account and then navigating to the correct share?