Have you tried DBCC MEMORYSTATUS? If not, you will find more information in this link http://support.microsoft.com/kb/907877

No problem. Could you please provide the source of the query? Thanks in advance!

You may want to change the title. Your question is not related to the CPU utilization.

Maybe you should write a blog about it and provide a more detailed description of what happened. You could use screenshots.

dm_tapas (7/12/2013)

---

Thanks for the reply.

Yesterday it happened... SQL was not allowed any new connections..but it was showing 99 % CPU usage by SQL.

we restarted the server ... and server is...

To answer your question, you can find information about sp_spaceused here. When I'm checking disk usage by a database I usually use the disk usage standard report on SQL...

I'm nott a big fan of shrinking a database, if you have enough space on production, maybe worth it to keep it as it is.

Could you please answer Steve's questions?

How were you trying to connect to the Server when using SSMS? Did you use the full Servername + instance (If applicable)? Did you try using the portnumber to connect?...

Try this:

create table #temp

(

id int,

strg varchar (5),

[index] tinyint

)

insert into #temp

values (1, 'abc', 1)

declare @strg varchar (5)

select @strg = case when ID = 1 and [INDEX] = 1

then strg

else '0'

end

from...

You may want to read the information in this link http://msdn.microsoft.com/en-us/library/ms177440.aspx

Check this link[/url].

faisalfarouqi (1/29/2013)

---

Thanks. to all you guys.

I've finally come up with a script that does the trick for me, and can be helpful for others as well. Now, here are the...

Hi, please accept my apologies for not getting back to you before, but I have been a bit busy....

Could you please add the attachment in another format? I'm not able to open it.