SQLRNNR

Forum Replies Created

Viewing 15 posts - 9,751 through 9,765 (of 19,560 total)

RE: Memory

Brandie Tarvin (6/9/2011)
Then consider your issue might be that you have too much database and not enough memory. Altering the memory allocation is unlikely to fix performance issues if the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 11:46 am

#1336572
RE: Are the posted questions getting worse?

Brandie Tarvin (6/9/2011)
jcrawf02 (6/9/2011)
Jim Murphy (6/9/2011)
GilaMonster (6/9/2011)
I post too much.
Congrats Gail! That's awesome.
The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 11:14 am

#1336552
RE: PerfectDisk Vs DisKeeper

I have used both of them and there is no real comparison. PerfectDisk by far outperforms DisKeeper.
Unfortunately, if you have heavy fragmentation at the OS level - you would...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 11:12 am

#1336548
RE: Indexing a nightly truncated table

For that many records and if you are having performance issues, then yes add a Clustered Index where appropriate.
If performance is not an issue and the tables are bulk load...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 11:08 am

#1336541
RE: How can I copy data easily between 2 identical databases?

ricer (6/9/2011)
This is straigtforward and using the four part name to access the Linked server data shouldn't cause any problem.
Not sure how using openquery is going to solve anything if...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 11:01 am

#1336536
RE: Shown up by a developer

Grubb (6/9/2011)
Ninja's, some data there:
No long-term locking affecting it (lowest I can set the threshold is one second). However, running that often, every bit is a problem!
However, would a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:58 am

#1336535
RE: Shown up by a developer

The answer to that question is probably able to be seen in the query plan after the index create.
One possible explanation - fragged heap that just got a clean index...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:55 am

#1336530
RE: Memory

If you only have 4gb RAM available, then yes I would venture to go that route. The OS typically needs no more than that 1GB but mileage varies. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:52 am

#1336523
RE: Shown up by a developer

opc.three (6/9/2011)
Since it is a heap, and you were deleting from it every 5 minutes (and I assume something else was inserting into it just as often) it could have...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:50 am

#1336520
RE: Shown up by a developer

This table has a high volume of inserts as well as the deletes?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:45 am

#1336510
RE: create table in a script t sql !?

The brackets are telling the database engine that all characters between them are part of the table name. Thus you have @t as your table name instead of your...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:44 am

#1336509
RE: PErformance difference with Management Studio

Then I would be looking for something that is blocking or contending with resources.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:40 am

#1336503
RE: PErformance difference with Management Studio

So direct on the server runs that slowly as well?
Are you sure that the workstation that performs quickly is pointed correctly to that server? Maybe an alias is redirecting...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:35 am

#1336499
RE: Memory

Also note, if you are going to change your max memory setting, you should change your min memory setting as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:33 am

#1336497
RE: Are the posted questions getting worse?

Anybody ready to start the countdown for 30K?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

June 9, 2011 at 10:31 am

#1336493

Viewing 15 posts - 9,751 through 9,765 (of 19,560 total)