Viewing 15 posts - 16 through 30 (of 62 total)
Post your feedback, after your restart. I have to do the same thing to one of my server.
May 17, 2004 at 3:05 pm
Get the correct sp_helpdb script from somewhere else, and recomile it under master db.
It could be, someone played with this script.
OR.. take the existing script and debug it, line by...
May 17, 2004 at 3:03 pm
Do the first backup log command a few time, and then try shrinkfile command. It will be shrinked to your desired size.
Also, the second command 'truncate only' is useless and...
May 11, 2004 at 12:22 pm
I just did a fresh download and applied it. The same errors.
February 25, 2004 at 2:48 pm
1. Any new code released to production? Can be an infinite loop of sql queries bounding the system.
2. Parallelly check all processor time & SQL Server:Databases: Transactions/sec. If they...
September 25, 2003 at 10:42 am
mccork, Steven,
Thanks for you replies.
1. Yes. Only sqlserver is using all the cpu, and the second is the system idle process.
2. customerCode is not a...
September 24, 2003 at 11:16 am
OK. here are the perfmon results.
cache hit ratio 100% no memory issue.
No physical disk issue, all low values
Processor-%user time high.
sql access methods: index searches/sec high
sql access methods: range scans/sec high
processor...
September 23, 2003 at 12:38 pm
Never mind. I found out.
http://support.microsoft.com/?kbid=814572
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306908
September 15, 2003 at 12:45 pm
TableName->OpenTable->Return All Rows; does it bring the same count as QA?
After all your update statistics, can you do a table->refresh from EM, and check ?just curious...
August 25, 2003 at 4:28 pm
Yes. Profiler and Perfmon side by side.
We had to stop the client from placing orders. Log in with a single user from the front end. Tracked all sql; as soon...
August 25, 2003 at 4:18 pm
Thank you all for your suggestions.
We found out, why cpu was 100%. It was nothing wrong with the sql server. From the java frontend application, one process was...
August 25, 2003 at 12:02 pm
Nothing new installed. We put patches for virus. Page file was defined for 4gb in C&E drive. I had to reboot and cleanup and make room for...
August 22, 2003 at 4:49 pm
spid 124 Mail Session Started
Spid 124 Error: 1073759778 Severity 1
August 21, 2003 at 3:32 pm
I do dbcc reindex regularly. Even I did dbcc checkdb came out 0 errors. In process, only sqlserver is eating up the memory and cpu. We did...
August 21, 2003 at 2:51 pm
WOW !! Thanks much. PKZIP command line utility solved my problem. Thanks again.
August 12, 2003 at 2:37 pm
Viewing 15 posts - 16 through 30 (of 62 total)