Viewing 15 posts - 16 through 30 (of 231 total)
Imo, You can test up to a maximum of 30 days as passive nodes can function as active server for a maximum of 30 days.
Doesn't categorically states primary should be...
September 22, 2015 at 6:32 am
lyle.schow 28602 (9/17/2015)
create scripts ot create the database objects needed in on the new server, attach the databases to the new server, then run the scripts to create the objects...
September 17, 2015 at 9:53 pm
We are planning to implement a sharepoint 2013 farm. What version of solitaire server recommended, Sql server 2012 or 2014?
Depends on what kind of features you want to...
September 15, 2015 at 8:56 pm
The windows account you are using is not recognized on the SQL instance you are attempting to login.
Please check if you are using the correct windows account to log...
September 14, 2015 at 9:44 pm
2 options.
1) SQL Server errorlog - Gives detailed info on the failover from primary to secondary
2) On Always dashboard look for "View Always on Health Events" at the right hand...
September 14, 2015 at 1:30 am
Did you include step level output?
Anyways, can you check if checkdb completed for all databases at the scheduled time via SQL Error log?
September 14, 2015 at 1:25 am
May I know why opted for such a method... was that because it was on recovery pending after always on failover?
Was it just one db on always on group that...
September 12, 2015 at 4:17 am
Most likely it is still in recovery rolling forward the entries from t log..
run the following query and pay attention to the columns last_redo_time,last_harden_time, suspend_reason_desc
select replica_server_name as servername,db_name(database_id)...
September 12, 2015 at 3:16 am
Do configure the log to write to a text file to get the full error message. meanwhile, you may also check the SQL Server error log to see if the...
September 10, 2015 at 4:07 am
From SQL layer, its hard to track a sequential or random I/O. Refer to the link below for a good explanation.
September 10, 2015 at 3:55 am
Though I couldn't exactly get what you are doing in the package, the error message states that
Login failed for user 'nice\rmX$'. Connection name : rm.rm
Can you verify the connection...
September 6, 2015 at 9:57 pm
Yes, I agree that MTL wouldn't totally account for all the missing memory. Just wanted to point out that, it is not covered in os_memory_clerks.
September 6, 2015 at 4:38 am
If my guess is right, the reason could be this.
physical_memory_in_use_kb shows the total memory usage of SQLServer process which includes Buffer pool + Memory to Leave (MTL) area.
Sum of...
September 5, 2015 at 11:02 pm
Microsoft has already published an eBook for Always on troubleshooting.
Besides these, refer Microsoft white papers ( 3 of them ) on Always on itself , to get a clear...
September 4, 2015 at 3:08 am
SQL!$@w$0ME (9/3/2015)
Hi Raj, total server memory is 100GB. RAMMAP shows 'sqlserver.exe' as the top process (24 GB).
Step 1 : Run the script I posted above.
Step 2: Try to find the...
September 3, 2015 at 7:12 am
Viewing 15 posts - 16 through 30 (of 231 total)