Viewing 15 posts - 16 through 30 (of 49 total)
So that means my question is really complicated or really stupid....
November 20, 2014 at 7:05 am
Right now I'm just following the exercises in the book but we do have a SQL 2008 R2 two node cluster that I will be upgrading to 2012 soon.
January 21, 2014 at 4:56 am
I'm not sure if there is a SCOM plug-in for Veritas Clustering. We prefer to have one point of contact when something goes wrong (Microsoft).
Not always possible though.
January 21, 2014 at 4:53 am
I usually create a stored proc on all my servers using the query below and call it sp_who3. It will give you all the details you need to troubleshoot.
select
a.session_id,
start_time,
b.host_name,
b.program_name,
DB_NAME(a.database_id)...
January 21, 2014 at 4:49 am
You could also use filegroup backups. Move all the user tables to a separate filegroup and back up and restore just the tables you need.
Keep in mind any foreign...
January 20, 2014 at 6:19 pm
There is so many variables to your question I'm not sure where to start. How do you know it's SQL verses some other process?
How much available memory?
How much paging?
What...
January 20, 2014 at 6:13 pm
If you use Microsoft SCOM monitoring in your environment like we do, I would stick to Microsoft clustering
January 20, 2014 at 6:06 pm
GilaMonster (4/19/2013)
McSQL (4/19/2013)
Start with the missing indexes...You can't add indexes to a sharepoint content database without losing all support.
Really, I didn't know that. As soon as I created the missing...
April 19, 2013 at 8:12 am
I'm trying to performance-tune the SharePoint WSS_UsageApplication database which is getting hit pretty hard. I noticed the auto stats were off, there were missing indexes and one single mdf file.
April 19, 2013 at 7:46 am
I was able to successfully delete the mirror database but not the principal. I ran a restore with recovery and deleted the endpoints. The database deleted without errors.
January 3, 2012 at 7:31 am
WOW! That is great information from everyone. You guys rock!!! I will go with simple and batch jobs with backups in between. Now I have to figure out how to...
May 2, 2011 at 4:33 am
Remove the Builtin\Administrators group from sysadmin in SQL. Encrypt the db's and give the users only permissions they need. If it's a Windows computer you could also encrypt the folder...
March 11, 2011 at 4:55 am
What if I do not want the user to see anything besides the SP and Views?
I granted execute and view, they can't see anything until I also give 'connect'
November 8, 2010 at 4:52 pm
Viewing 15 posts - 16 through 30 (of 49 total)