Viewing 15 posts - 2,656 through 2,670 (of 2,883 total)
I've also seen this issue when I leave SSMS open for weeks at a time or when my system gets low on resources. You say you have 8GB of RAM...
April 4, 2017 at 9:03 am
I think like Grant said, I'd test the restore. Go with the assumption of worst case scenario:
the VM gets corrupted
Time how long it takes from getting your...
March 31, 2017 at 11:29 am
I'd look at what is causing high CPU. is it SQL or something else?
If it is SQL, I'd start by looking at what is running on the SQL instance....
March 31, 2017 at 11:18 am
That looks right to me.
A few things to check though:
1 - remote desktop into the physical/virtual machine hosting the 2012 instance (the machine that you are trying to...
March 31, 2017 at 10:57 am
I think it depends on what the processing is actually doing. SQL does some things really well, others poorly. C# does some things really well, and some things poorly.
March 31, 2017 at 10:47 am
I think knowing what you are trying to accomplish would be a good first step.
That being said, you can make a FK point to any PK. So there...
March 31, 2017 at 10:34 am
Not sure what "best practice" is, but we swapped windows defender out for a more enterprise ready antivirus and then set up ignore rules on the databases as those get...
March 31, 2017 at 10:26 am
March 28, 2017 at 3:27 pm
March 28, 2017 at 2:50 pm
To clarify, when you say "16 GB" is that the memory allocated to the resource pool or to the Server?
Does your resource pool have enough space for that...
March 28, 2017 at 12:10 pm
Another thing to watch for is Windows "Available" memory vs "Free" memory. Available memory is Free + Cached and Cached doesn't get cleaned up all that quickly unless there is...
March 28, 2017 at 12:01 pm
What tools are you using to build this out to display to end users? And does the formula table change often? If the formula table will change very infrequently or...
March 28, 2017 at 11:45 am
I am fairly confident that subscription processing is done in parallel. We have a lot of report subscriptions that occur in parallel.
Is the 16 GB of RAM for...
March 28, 2017 at 11:14 am
Where we work, nobody releases their own code changes to live. With source control, we have a "don't release your own changes to master" policy, but it does happen by...
March 24, 2017 at 8:29 am
I am assuming this is 1000 SSRS subscriptions.
On top of what Sue suggested, I would check for database growth of both tempdb and your report server database and log...
March 22, 2017 at 1:52 pm
Viewing 15 posts - 2,656 through 2,670 (of 2,883 total)