Viewing 15 posts - 45,736 through 45,750 (of 49,552 total)
Have you enabled remote connections?
On the machine you can't connect to, run the surface area config and check that remote connections have been enabled.
When you run the Surface area...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 3:51 am
TempDB is completely recreated every time SQL starts. What you're seeing is normal and expected.
If you want permission changes to persist through a restart, you'll have to set them on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 3:34 am
Hmmm....
Has the slow execution reoccured? Is it happening regularly?
As more general comments:
Why are you using dynamic SQL in one place? I can't see anything in there that would need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 3:31 am
There are some values in that column that cannot be converted to numeric. You're going to have to find those values and either remove them or exclude them from the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 2:16 am
Don't shrink your database. It causes massive index fragmentation and the DB will quite likely just grow again, possibly causing file-level fragmentation.
See - shrinking databases[/url]
Why do you want to shrink?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 1:56 am
That's a compile time of 16 sec! That's a little extreme.
Do you have contention for your procedure cache? (Are you seeing blocking with a [compile] description)
If you check perfmon, what...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 1:28 am
Parameterise all queries in your front end app. Do not concatenated together SQL statements and execute them.
Preferably, use stored procedures for data access only and do not allow the application...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 1:21 am
The error message is getting cut off. You'll need the entire message before you can find a the cause
Go into the job step. On the advanced tab there will ba...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 12:41 am
Have you looked at database snapshots? It seems to me that creating a snapshot may solve your problem.
They do have an IO load impact though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 12:30 am
ltoso (7/11/2008)
Hi,thanx for usefull information guys, the reason why i cannot disable the sa account because helm the web hosting control panel uses this account to create databases
That's a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 12:11 am
ltoso (7/11/2008)
Hican you guys tell me what will be the straight forward way to change the password for sa account through sql server management studio,
I already did.
You can rename...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2008 at 12:05 am
Jeff Moden (7/12/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2008 at 11:57 pm
Ben Blum (7/13/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 13, 2008 at 11:55 pm
TRACEY (7/12/2008)
A lot of data 🙂I was trying to get it in MG to explain to people how much data they are requesting...blocks will not mean too much to them.
So...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2008 at 9:53 am
The logical reads and writes are a count of pages, not MB, GB or other size measurements.
A page in SQL is 8kB, so if profiler tells you that for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2008 at 8:39 am
Viewing 15 posts - 45,736 through 45,750 (of 49,552 total)