Forum Replies Created

Viewing 15 posts - 286 through 300 (of 360 total)

  • RE: need inputs for creating a stored proc

    Thanks again Bill...I installed the drivers and configured them...but when I tried to create the linked server it hangs...continuous running..its been 45 mins now..i amthinking to kill the process

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 23, 2011 at 2:08 pm

    #1412477

  • RE: need inputs for creating a stored proc

    Also, should I have the MAS90 drivers installed on the server where SQL Server is installed?

    Thanks a lot for your help

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 23, 2011 at 11:42 am

    #1412394

  • RE: need inputs for creating a stored proc

    While configuring the linked server, which user shd i specify in the security tab of the new linked server window? I meant the "Local Server Login to remote server login...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 23, 2011 at 10:10 am

    #1412343

  • RE: need inputs for creating a stored proc

    Thanks for the url

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 23, 2011 at 7:33 am

    #1412194

  • RE: Performance Monitoring with Dynamic Management Views

    Thanks much for the article Ron. For the perfmon counters where can I get the threshold values.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 17, 2011 at 8:19 am

    #1409249

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    OK Thanks...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 14, 2011 at 12:58 pm

    #1407492

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    Ninja..for the indexing I have identified the top 50 high cpu consuming queries and went by each individual graphical execution plans and created the non clustered indexes suggested by the...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 14, 2011 at 12:13 pm

    #1407470

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    Ninja

    Please find the image attached

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 14, 2011 at 10:05 am

    #1407374

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    Gail,

    I noticed too many sql timeouts yesterday night. WHen I query on the monitor table i have in place I was seeing some of the sessions were in suspended status...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 14, 2011 at 10:00 am

    #1407366

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 14, 2011 at 9:52 am

    #1407354

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    NINJA Please find the result set below:

    WaitType Wait_SAvgWait_MSResource_S Signal_SWaitCountPercentage

    ASYNC_NETWORK_IO137941.7179.08 ...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 14, 2011 at 9:51 am

    #1407351

  • RE: Decoding the keys for LCK_M_X wait type

    Yep..that works..I was on a different database. Thanks Gail.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 11, 2011 at 2:44 pm

    #1406604

  • RE: Decoding the keys for LCK_M_X wait type

    I used the script below to identify the name of the object. But all I see is nothing in the output. Do I need to enable a trace flag for...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 11, 2011 at 1:53 pm

    #1406588

  • RE: timeouts on SQLServer with SQLTrace_Lock

    OK Thanks

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 10, 2011 at 2:36 pm

    #1406025

  • RE: timeouts on SQLServer with SQLTrace_Lock

    Thanks Jared I will start digging into these

    Also, In the sql server error log I am seeing the below errors at the same time when the timeouts occurred.

    Process 0:0:0 (0x864)...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

    November 10, 2011 at 1:30 pm

    #1405995

Viewing 15 posts - 286 through 300 (of 360 total)