Viewing 15 posts - 76 through 90 (of 583 total)
You can use sys.dm_os_memory_clerks to check memory usage. It should give you the relevant information you are looking for.
select
type, sum(pages_kb) as pages_kb
from...
March 17, 2015 at 8:28 am
2012 not able to connect to 2014 would make sense as the 2012 powershell provider would not "know" about the computermanagement12 namespace, thus not try to connect to it.
March 17, 2015 at 8:00 am
Unfortunately I have not yet found a solution or tried to install 2012 tools to see if that resolves the issue. For your servers at work, check the available namespaces...
March 16, 2015 at 10:07 am
check what the query is waiting on. you can use the following query. My guess is the wait type for the query will be ASYNC_NETWORK_IO, which would usually mean the...
March 6, 2015 at 10:42 am
Does your table have two columns (value a, value b) or three columns (value a, date, value b)? If it's the latter, you could get max date for each value...
March 6, 2015 at 10:37 am
It appears as though the clustered keys get added to the non-clustered index in the same order as the clustered key. here is the example I used to check this.
first...
March 5, 2015 at 2:31 pm
the script that is failing is checking whether the DatabaseMailUsersRole exists in msdb and if it does whether there are users in it. It doesnt seem to do anything if...
March 2, 2015 at 9:14 am
you could try microsoft kerberos configuration manager to help troubleshoot.
you could try creating SPN with instance name.
ex
MSSQLSvc/servera.domain.com:instance1
MSSQLSvc/servera.domain.com:instance2
MSSQLSvc/servera.domain.com:instance3
February 27, 2015 at 3:10 pm
The attachment shows the uninstall was successful on the database engine. It failed on the Data tool, integration services, and Data Quality Client. Do you have these items installed on...
February 27, 2015 at 2:53 pm
If you start your powershell session with an account that is local admin of the remote server, it should work. If local admin is not possible you could try having...
February 23, 2015 at 2:44 pm
Profiler should work against any edition and versions. I can profile an express instance without issue( i dont have a web edition to test with). Its just that you...
February 19, 2015 at 11:35 am
The SOS_SCHEDULER_YIELD wait is usually due the a thread running longer than 4ms and a giving up it's spot in the running queue. This can be due to large table...
February 9, 2015 at 10:57 am
if you are installing SQL Server enterprise 2012 on a box with 24 core then you need to buy a license for all 24 cores. http://blogs.technet.com/b/uspartner_ts2team/archive/2011/11/30/a-concise-sql-server-2012-licensing-overview.aspx
As for more cores or...
February 4, 2015 at 1:36 pm
Do you get this error every time you login as sa?
If it was only at the point of password change, is it possible that a system or user process...
February 3, 2015 at 7:42 am
You can try this query from sp_BlitzCache at http://www.brentozar.com/blitzcache/no-join-predicate/. It will look through your plan cache to find all statements that have nojoinpredicate warning.
January 27, 2015 at 1:26 pm
Viewing 15 posts - 76 through 90 (of 583 total)