Viewing 15 posts - 376 through 390 (of 644 total)
If you are facing this issue just after you applied SP1 you may try to unistall the SP & see what happens. Otherwise, I think you will need to restore...
February 20, 2012 at 6:45 am
nadersam (2/20/2012)
Thanks for your reply.It went above 70 %
I think the alert considers "100" as "1.0" as CPU is calculated by its base, so you need to set the baseline...
February 20, 2012 at 6:41 am
matrenin (2/20/2012)
John Mitchell-245523 (2/20/2012)
February 20, 2012 at 5:31 am
nadersam (2/20/2012)
I created an alert under sql server agent alerts.
I selected type as sql server performance condition alert, Object:Sql server :Resource Pool Stats,Counter :Cpu usage %, Instance:default,Alert if:Counter rises...
February 20, 2012 at 5:12 am
Still you are not able to connect? Do you have any third party tool which continuously pings SQL Server? If yes, can you stop the services of that tool also?...
February 20, 2012 at 5:08 am
Saggy (2/20/2012)
Login failed for user 'MODERN\saaz'. Reason: Server is in single user mode. Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)
Please make sure that all...
February 20, 2012 at 4:55 am
Actuly 2 new posts got added in the same thread today prior to my response, so replying to them 🙂
February 20, 2012 at 4:06 am
How do you identify the StartTime & EndTime for a particular event? I don't see any EventId column on the basis of which you can decide. Please provide the name...
February 20, 2012 at 4:02 am
have you tried to start the SQL Server service with -f startup parameter?
February 20, 2012 at 3:59 am
I am not sure why people are so much ineterested in breaking log chain by changing the reocovery model to SIMPLE, just to avoid the log file growth during Re-indexing.
Use...
February 20, 2012 at 3:45 am
kranthi.india123 (2/20/2012)
my apologizes about the confusion.please see the below sites.http://www.sql-server-performance.com/forum/threads/srinking-database-for-logshipping.30829/
http://www.bigresource.com/Tracker/Track-ms_sql-rI2McykB/
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140751
and so can in test it.please provide any script for shrinking databases.through job
Same code that has been earlier provided can...
February 20, 2012 at 3:17 am
kranthi.india123 (2/20/2012)
DBCC SHRINKDATABASE(N'LearningCT', 10, NOTRUNCATE)(It shows the retain freed space in database files)
DBCC SHRINKDATABASE(N'LearningCT', 10, TRUNCATE_ONLY)(It shows the return freed Space To OS level)
Thank u for...
February 20, 2012 at 1:56 am
Use the PageLifeExpectancy (PLE) counter to monitor memory issues. Buffer cache hit ratio is not a very good counter to look for when it comes to monitor issues related to...
February 18, 2012 at 9:46 am
jcoffey-872763 (2/18/2012)
February 18, 2012 at 9:34 am
Eugene Elutin (2/17/2012)
Eugene Elutin (2/17/2012)
GilaMonster (2/17/2012)
Eugene Elutin (2/17/2012)
GilaMonster (2/17/2012)
An nvarchar(40) holds 40 characters.and its length is 80 bytes, to accomodate unicode...
Its length is anything from 2 bytes to 82 bytes...
February 17, 2012 at 8:49 am
Viewing 15 posts - 376 through 390 (of 644 total)