Viewing 15 posts - 1,366 through 1,380 (of 1,640 total)
What counters should I monitor to get information what caused the slow response of applications that has their databases on the server?
Thanks
June 12, 2011 at 1:29 pm
Thanks, if I setup a perf log on the sql server that has the slow response time, does the performance monitor itself affects the performance too?
Is there a way that...
June 12, 2011 at 10:24 am
Thank you.
I go to link above called My posts, it only returns 150 results.
Where can I find the other posts?
Thanks
June 12, 2011 at 10:21 am
Thanks, I setup a job using sp_who2 to catch.
See below, the lines may be now in align, but I cannot find a way to post corretlly
SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIO
11SUSPENDEDsa..masterCHECKPOINT11528136547
11SUSPENDEDsa..SharedServices2_DBCHECKPOINT11528136570
11SUSPENDEDsa..masterCHECKPOINT11532836600
11SUSPENDEDsa..masterCHECKPOINT11532836600
11SUSPENDEDsa..masterCHECKPOINT11551536665
2SUSPENDEDsa..(null)LOGWRITER166140
2SUSPENDEDsa..(null)LOGWRITER166171
2SUSPENDEDsa..(null)LOGWRITER166171
2SUSPENDEDsa..(null)LOGWRITER166171
2SUSPENDEDsa..(null)LOGWRITER168359
83SUSPENDED.WSS_Content_CollaborationSELECT76640468108
83SUSPENDED.WSS_Content_CollaborationSELECT78281479179
83SUSPENDED.WSS_Content_CollaborationSELECT96500575951
June 12, 2011 at 10:16 am
How can I monitor the backup file size increase?
June 11, 2011 at 3:16 pm
Thanks, so I think I can setup a sql job that use transact_sql and run sp_helpfile. to output to a text file.
You said there are serveral ways, so beside sp_helpfile,...
June 11, 2011 at 2:54 pm
Thank you all, it is a transaction log backup make it to smaller percentage of usage.
we have autoshrink off, and no shrink db jobs.
June 11, 2011 at 1:40 pm
Thank you.
I will mark this post as a bookmark for my reference of memory option
So in my case, this server is 64 bits, and only 4 gb memory, it hosts...
June 11, 2011 at 12:21 pm
Thank you.
I'm a little confused again. All our servers are 64 bits. And sometimes I heard from the forum microsoft recommend not changing the default settings for memory, and let...
June 10, 2011 at 3:31 pm
Sorry, I meant it hosts databases for those applications and databases for sharepoints.
No application other than SQL server is installed on this server. All our SQL servers are designated box...
June 9, 2011 at 11:19 am
If all depends, this will not help.
It's impossible for us now to get another sandbox for us to play with, no budget for that, the server hosts 4 vendor...
June 9, 2011 at 11:09 am
Thank you.
I will try that.
I always wonder: does microsoft recommend using default memory settings OR is it good to allocate memory mnually like this?
Thanks
June 9, 2011 at 10:56 am
I should say it more clearer.
The box is only for SQL server, it hosts databases for diffrent applications.
So shall I allocate 1 gb to OS, and 3 to SQL server?
June 9, 2011 at 10:48 am
Thank you.
What I want to figure out is license issue. I don't have access to their PC to check out.
But I have a tool called Discovery that collects information through...
June 8, 2011 at 10:14 pm
Viewing 15 posts - 1,366 through 1,380 (of 1,640 total)