[/quote]

Connections to the database take resources and do consume memory. That added to the waits that Grant asked about would help to understand memory pressure.

Did you check with your...

saidapurs (1/5/2013)

---

Hi All,

I have upgrade the sql server 2005 to 2008R2 successfully but still it showing the Management studio in startup menu but not able to...

Ok. Thank you. I will read further.

SueTons.

GilaMonster (1/5/2013)

---

SQLCrazyCertified (1/4/2013)

---

You mentioned that SQL using all of it's memory which is allocated to it is a normal behavior, if this is true, when does the SQL release the...

Is there any other way to release the memory? Or how can we find why SQL server is using high memory?

What are some of the causes of using high...

SQLRNNR, There are only 50 active connections.....so, I don't think this is the issue.

Joie Andrew, Had complains that everything is running slow and I coudn't find anything else other than...

craig-404139 (1/3/2013)

---

No memory issues (We have 172 GB on the server). Log files are not on the same volume as the temp db. I've worked closely with our Compellant SAN...

I am interested in hearing if you find out the cause for this. Sorry to say, I am not sure how to tackle this issue.

230 databases on a production...

Shadab Shah (1/3/2013)

---

Hi all,

I am a newbie in SQL Server. I was exploring fragmentation topic. i came across two term which were most confusing to me and i tried to...

Thanks for all your inputs.....I was thinking it is some type of policy settings.

Thanks again.

SueTons.

Hi Lowell & all,

I've tried what you suggested and it does not work for my scenario. I am able to copy the data from remote server to my work...

Lowell (1/2/2013)

---

for me, a VPN session just gives me an ip and DNS services on my work LAN so i can see all the servers on the lan.

so if i...

You sure about this?....Have you done it?....apparently, it's not working for me...

Hi Gsquared,

Maybe I should have phrased differently, what...

Hi Lowell,

I don't exactly follow all the steps you mentioned above.

Can you please provide step by step for example, I want to create a

Linkedserver from SQL to Oracle.

What are...