Viewing 15 posts - 91 through 105 (of 231 total)
Are you getting the same for all databases or just a single one.
Can you try firing sp_helpdb and check whether something is unusual for this database?
September 29, 2010 at 8:45 pm
my mistake. Thanks for correcting
September 29, 2010 at 4:32 am
Please check the default trace file stored in errorlog folder.
To find your default trace
SELECT *
FROM fn_trace_getinfo(default);
GO
USe the following function to dump the trace details into a table
SELECT * FROM...
September 29, 2010 at 4:07 am
Removing unwanted objects is a good thing, but thats less likely to be the reason for your problem. Do a thorough analysis of the problem.
Start checking from Task manager...
August 13, 2010 at 1:52 am
If interested please read http://strictlysql.blogspot.com/2010/02/database-server-is-slow-can-you-please.html%5B/url%5D
August 13, 2010 at 1:35 am
@Gail,
Odd, emergency should imply single user. Did you do anything at all to the DB since setting it to emergency?
To quote books online
When EMERGENCY is specified, database is...
June 15, 2010 at 10:06 pm
@arr.nagaraj i will work on CPU thing
CPU used by SQL Server can be found from sys.dm_os_ring_buffers.
Refer http://strictlysql.blogspot.com/2010/06/finding-cpu-utilization-in-sql-server.html%5B/url%5D
June 14, 2010 at 1:01 am
@andriod,
Try "sqlcmd -L" on the command prompt and check whether it helps you.
June 10, 2010 at 7:47 am
Hi Stanley,
Good and informative article. Does it require any ports to be opened?
June 10, 2010 at 12:05 am
it seems to me that the database should be smart enough to analyze the SELECT query and recognize that it cannot acquire all the necessary data using...
June 7, 2010 at 9:30 pm
@tosscrosby,@Bhuvanesh,
Yes true that girls/ladies are lesser represented. But right now SQL communities' top contributers are women.
Gail Shaw
Kalen Deanley
Kimberly tripp
Michelle ullford (sqlfool)
Lyn shea
Personally, I am huge huge huge...
June 4, 2010 at 10:15 am
Even I work for Govt firm of sorts and its same here as well..
SA's handle stuff like windows patching..DBAs do the DB patches,hotfix..
DBAs do have windows logins to server with...
June 4, 2010 at 8:27 am
@maxibeck,
check the attachements given at the end of the article.
June 4, 2010 at 1:31 am
Refer to the article belowto narrow down on the queries that are casuing the tempdb to grow.
http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html
May 28, 2010 at 7:05 am
Viewing 15 posts - 91 through 105 (of 231 total)