Viewing 15 posts - 391 through 405 (of 463 total)
Adrian,
Can you run the following query from the query analyzer and see what is taking 100% of CPU
Open Query Analyzer and run the following
select * from sysprocesses where spid > 50...
May 5, 2004 at 1:10 pm
Something which you might want to check with the SAN team is whether you have striped or Concatenated volumes. Also see if they see any hotspots in SAN.
April 22, 2004 at 10:14 am
Can you check the perfmon counter Disk Queue length and see whether it is not exceeding 2*no. of processors. Regarding the microsoft stress test utility, below is what microsoft has...
April 22, 2004 at 10:04 am
You can type it in SQL Query Analyzer. You can open SQL Qeury analyzer from the tools tab in enterprise manager or go to start-> run and type in...
April 6, 2004 at 4:46 pm
FYI- If you have windows resource kit installed, you can do it with sc.exe
April 6, 2004 at 4:43 pm
John,
I tried to enable awe on one of our 3.8 gb machine without includingthe /3gb switch and i saw the same results which you saw. It showed me close to...
April 1, 2004 at 8:59 pm
I do agree that 14 GB of log file space is big but i don't think it should really hit performance. The only time it can hit is depending on...
April 1, 2004 at 8:29 pm
Paul,
How are you connecting to the database. i mean do you connect through a Trusted_connection or SQL Authentication ? And whta is your connection string and from where are you...
March 24, 2004 at 7:16 pm
When you query sysprocesses for spid > 50, do you see CXPACKET waittype. if yes then,what is the setting of the advanced parameter max degree of parallelism ? By default the...
March 24, 2004 at 7:02 pm
March 11, 2004 at 9:00 pm
With the backup duration provided by you, i don't think it should be the cause of the issue. have you thought about moving the tran log dump about 30 minutes...
March 10, 2004 at 9:14 pm
One of the reason why you might see sleeping threads would be if connections are being pooled by your application. Regarding active threads, Something what i was told from one...
March 10, 2004 at 9:01 pm
Are you moving the SQL Server to a new domain ? Will you be re-naming the server ? Please provide some more details.
March 10, 2004 at 8:50 pm
We use CDOSYS to send mail. Below is the link to the article.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839
March 9, 2004 at 9:28 pm
Viewing 15 posts - 391 through 405 (of 463 total)