Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Looking for best index
Message
From
04/03/2016 02:59:10
 
 
To
03/03/2016 19:12:57
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows 2008 Server
Miscellaneous
Thread ID:
01632184
Message ID:
01632517
Views:
40
>>size db ?
>>size ram ?
>
>The database would be around 200 GB.
>
>The ram is 38 GB.

To date, my experience with SQL Server,
tells me that if the relationship SIZERAM / SIZEDB is very small 1
it is common to have performance degradation.
Certainly the size of RAM it must be larger than the size of the Client table including the indexes.

Another issues it is a bad optimization of @variables.

Do this test:
restart SQL service
exec this:
DECLARE @NoEntity Int
DECLARE @VehicleMake Varchar(30)
DECLARE @VehicleModel Varchar(30)

SET @NoEntity=19
SET @VehicleMake='VOLKSWAGEN%'
SET @VehicleModel='"CABRIOLET*"'

SELECT Client.PrimaryKey
 FROM Client (NOLOCK)
 WHERE Client.NoEntity=@NoEntity AND Client.VehicleMake LIKE @VehicleMake AND Contains (Client.VehicleModel, @VehicleModel)

-- time 1 ?

SELECT Client.PrimaryKey
 FROM Client (NOLOCK)
 WHERE Client.NoEntity=19 AND Client.VehicleMake LIKE 'VOLKSWAGEN%' AND Contains (Client.VehicleModel, '"CABRIOLET*"')

-- time 2 ?
post time 1 and time 2.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform